title

text

February 03 – 05 , 2016

PgConf.Russia 2016

Postrelease

  • more than
    0 participants
  • 0 speakers
  • 0
    minutes of conversation
  • 60 talks
  • offline
    format

Talks

Talks archive

PgConf.Russia 2016
  • Will Leinweber
    Will Leinweber Heroku

    In addition to providing a general purpose web platform, Heroku has a large, supporting Postgres service. Over the years, we've learned a lot about running Postgres at scale.
    In this talk, we'll cover:

    • why Postgres is attractive to run as a cloud service
    • how to provision, manage, and monitor a Postgres fleet
    • tradeoffs needed to make Postgres work in this environment
    • automating failure recovery
    • and more

  • Pavel Stehule
    Pavel Stehule freelancer

    • the architecture
    • the design and implementation of PL/pgSQL
    • the difference between PL/SQL and PL/pgSQL
    • the advantage and issues of PL/pgSQL

  • Teodor Sigaev
    Teodor Sigaev PostgresPro
    Anastasia Lubennikova
    Anastasia Lubennikova PostgresPro
    Alexander Korotkov
    Alexander Korotkov PostgresPro
  • Dmitry Dolgov
    Dmitry Dolgov Zalando SE

    Schema-less is definitely a trend in the data storage nowadays, and it's not only about NoSQL, but also about traditional RDBMS. Many relational databases (e.g. PostgreSQL, Oracle, db2, Mysql) allow to storing data in the schema-less json format and use their own more or less unique way to do that.

    This talk contains two parts:

    • Comparison of the json support in PostgreSQL and different relational databases, namely Mysql, Oracle, db2, MSSql in terms of supported features, functions and so on.
    • Performance benchmarks for databases with the advanced json support, namely PostgreSQL and Mysql, and the MongoDB on different workload types and configurations.

All talks