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
  • Teodor Sigaev
    Teodor Sigaev PostgresPro
    Anastasia Lubennikova
    Anastasia Lubennikova PostgresPro
    Alexander Korotkov
    Alexander Korotkov PostgresPro
  • Oleg Ivanov
    Oleg Ivanov PostgresPro

    In the speech we consider the current PostgreSQL planner model, then the possibilities of applying machine learning methods for planner improvement and the obtained results.

  • Dennis Ivanov
    Dennis Ivanov 2GIS

    • First aquaintance
    • Fight with replication
    • Partitioning and migration
    • Cross data-center use
    • v8, json, jsonb, jsquery
    • Version upgrade

  • Heikki Linnakangas
    Heikki Linnakangas Pivotal Ltd

    PostgreSQL includes several index types: GiST, SP-GiST, GIN, and of course, the regular B-tree. DBAs are familiar with using each of these for specific use cases, GIN for full-text search, GiST for geometrical data, and so on, but how do they work internally? What makes them suitable for the cases they're typically used for?

    In this presentation, I will walk through the internal structure of each of these index types, explaining what strengths and weaknesses each one of them have.

All talks