Top.Mail.Ru
PgConf.Russia 2017 | PGConf.Russia

title

text

March 15 – 17 , 2017

Postrelease

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

Talks

Talks archive

PgConf.Russia 2017
  • Alexander Alekseev
    Alexander Alekseev PostgresPro

    ZSON is a PostgreSQL extension for transparent JSONB compression. Compression is based on a shared dictionary of strings most frequently used in specific JSONB documents (not only keys, but also values, array elements, etc). In some cases ZSON can save half of your disk space and give you about 10% more TPS.

    VIDEO

  • Andrei Nikolayenko
    Andrei Nikolayenko IBS
    Alexander Korotkov
    Alexander Korotkov PostgresPro
    Борис Нейман
    Борис Нейман Mellanox
  • Илья Космодемьянский
    Илья Космодемьянский Data Egret

    Input-output (IO) performance issues have been on DBAs’ agenda since the beginning of databases. The volume of data grows rapidly and time is of an essence when one needs to get necessary data fast from the disk and, more importantly, to the disk.

    For most databases it is relatively easy to find checklist of recommended Linux settings to maximize IO throughput and, in most cases, this checklist is indeed good enough. It is however essential always to understand how the optimisation of those settings actually works, especially, if you run into corner cases.

  • Sergey Mirvoda
    Sergey Mirvoda Octonica, UrFU

    Experience we've got after 5 years of developing, deploying and improving BI system http://colibri365.ru used in government. I would talk about government IT reality and our way over it. Postgres performance improvements, using of latest features, overwriting of user generated queries to help query optimizer and other tweaks and hacks to tackle limited hardware problems. These lead us to number of computer science papers and (now committed) patches to Postgres (see Andrey Borodin talks for details).

    VIDEO

All talks