title

text

February 03 – 05 , 2020

PgConf.Russia 2020

PgConf.Russia 2020

PGConf.Russia is a leading Russian PostgreSQL international conference, annually taking together more than 700 PostgreSQL professionals from Russia and other countries — core and software developers, DBAs and IT-managers. The 3-day program includes training workshops presented by leading PostgreSQL experts, more than 40 talks, panel discussions and a lightning talk session.

Thems

  • PostgreSQL at the cutting edge of technology: big data, internet of things, blockchain
  • New features in PostgreSQL and around: PostgreSQL ecosystem development
  • PostgreSQL in business software applications: system architecture, migration issues and operating experience
  • Integration of PostgreSQL to 1C, GIS and other software application systems.
  • more than
    0 participants
  • 0 speakers
  • 0
    minutes of conversation
  • 62 talks
  • offline
    format

Talks

Talks archive

PgConf.Russia 2020
  • Alexander Korotkov
    Alexander Korotkov PostgresPro

    PostgreSQL 13 Feature Freeze is scheduled for April 2020. Two more commitfests are still accepting new patches. What we can say about PostgreSQL 13. It's possible that rotation rule will work so that new release wouldn't have as many new features as PostgreSQL 12 have. If even it is do, that would be good evolutionary release with a lot of medium feature and infrastructure changes, which prepares postgres for new leap. In this talk I will overview expected novelties in PostgreSQL 13. It would be more or less accurate, since there would be only one commitfest left, which results are possible to forecast.

  • Ivan Panchenko
    Ivan Panchenko PostgresPro

    In this tutorial, we will solve several programming problems using JSON functionality that extends SQL capabilities and virtually turns a relational database into an almost ready-to-use application server. :)
    We will learn how to use aggregates, both standard and custom, as well as review possible benefits of JSON recursive structure.

  • Vasiliy Puchkov
    Vasiliy Puchkov

    · Enterprise network traits, known problems and workarounds.

    · Year-long background of maintaining 24x7 1C + PostgreSQL systems

    · Pros and cons in comparison with MS SQL from DBA point

    · Stories of 1C systems migration from MS SQL to PostgreSQL

  • Heikki Linnakangas
    Heikki Linnakangas Pivotal Ltd

    Walk-through of extending PostgreSQL with a user-defined type. The journey begins from the basics, from creating simple domain types over existing types, and continues to implementing a full-blown datatype from scratch in C.

    PostgreSQL's advanced index types, GiST, GIN, and SP-GiST, are covered in enough detail to give an understanding of what each of them is good for. Support functions for each of them are shown for the example 'color' datatype.

All talks

Partners

PgConf.Russia 2020

Organizational

Informational

Technical

Partner