![Dmitry Belyavskiy Dmitry Belyavskiy](/media//2017/01/30/bel.jpg.180x180.jpg)
![Teodor Sigaev Teodor Sigaev](/media//2019/01/30/afe3e892723a73bf6d567bd5181b0.jpg.180x180.jpg)
LTREE: extending the syntax
At the end of 2018, I've got a request to extend the syntax of the ltree contrib. I'm finalizing the patch and going to speak about:
- the current state of the extension,
- the extended syntax, and
- the process of development and testing the extension.
Слайды
Видео
Другие доклады
-
Denis Smirnov КГБУЗ КДЦ Вивея
Greenplum: Internal Structure of MPP PostgreSQL for Analytics
As we all know, PostgreSQL is a classic vertically scalable database for OLTP loads. In parallel with PostgreSQL for many years there is its alternative horizontal-scalable MPP version of PostgreSQL, that is called Greenplum, sharpened for big data and OLAP workload. In my pitch I will show the internal architecture of Greenplum (distributed transactions, data sharding, partitioning with hybrid storage in external systems, column storage engines with compression, and much more), a comparison with the internal structure of PostgreSQL and the application areas of each solution are shown.
-
Konstantin Evteev X5 FoodTech
Standby in production
My talk will be about different cases of usage and setup of the standby server; examples how to setup standby linked to your archive( to make an opportunity to recreate standby from archive after primary crashing and promoting your old standby); Avito experience of usage of standby server for read-only queries: problems and solutions; monitoring of standby.
-
Andrey Fefelov Mastery.pro
Postgres + patroni + consul + s3 + walg + ansible = Simple HA cluster
Patroni is getting art of state standard framework for building HA clusters with postgres now.
During session we will build simple 3 node cluster using mentioned stack.
We will discuss patroni's architecture, and most interesting parameters from it's configuration. We will check how actually failover works and how could you initialise cluster.
After session you will be able to built such cluster from scratch in minutes using given ansible playbooks.
-
Miroslav Šedivý solute GmbH
Python and PostgreSQL Using psycopg2
Python may not be the fastest programming language on the CPU, but its fast and easy development saves a lot of costs between the keyboard and the chair. In this workshop we'll explore the most popular library for the access to the PostgreSQL server named "psycopg2" and write a short application using some of its useful features.