PGConf.EU 2019
Крупнейшая в Европе конференция посвященная СУБД PostgreSQL. Проводится ежегодно и каждый год в каком-то новом городе. До сих пор выбранные для конференции города не повторялись. Но в этом году конференция вновь проводится в Италии - в стране, в которой проводилась в самый первый раз. В 2019 году конференция PGConf.EU проводится уже в 11-й раз, в Милане.
В программе конференции
Фёдор Сигаев
технический директор Postgres Professional
PostgreSQL Major Contributor & PostgreSQL Committer
Доклад May the Force of hierarchical data be with you
How to work with hierarhical data in relational databases? PostgreSQL suggests to use standard SQL way: WITH RECURSIVE common table expression, it's very flexible way to operate with such data. And it is so flexible and powerful that it makes it difficult for the optimizer, so it could demonstrate unimpressive performance. There is a more straightforward way to work with hierarhical data, the way is a ltree extension. Ltree has a long success story and I would like to show new improvements of it, such as new syntax and new index support.
Александр Коротков
главный архитектор СУБД Postgres Professional
PostgreSQL Major Contributor & PostgreSQL Committer
Доклад Beyond the pushdowns – distributed query planning and execution
Nowadays, it's generally agreed that community way to sharding is combination of partitioning and foreign data wrappers (FDW). Naturally, one could turn a local database to distributed one by moving some data partitions to foreign servers.
A lot of efforts were spent to provide FDW a bunch of query optimization techniques including pushdowns of aggregates, joins and orderings. These optimizations allow to making more computations locally. That in turn improves scalability of query processing.
However, pushdowns are not enough for real scalability of OLAP queries, which requires complex processing of large amounts of data. Such queries requires so-called "re-partition", runtime redistribution of data between cluster nodes.
In this talk we present our work on distributed query planning/execution. It provides full-fledged OLAP query optimization including "re-partition". Our distributed query planner and executor require only few core modification, while being built in pluggable way using hooks and custom nodes. The efficiency of proposed approach will be shown on both syntactical and real-life benchmarks.
While being essential part of sharding, we hope distributed planner/executor will become part of community sharding roadmap.
Александр Коротков
главный архитектор СУБД Postgres Professional
PostgreSQL Major Contributor & PostgreSQL Committer
Bruce Momjian
co-founder of the PostgreSQL Global Development Group,
Senior Database Architect in EDB, Community Contributors
Community roadmap to sharding
Sharding is one of most wanted PostgreSQL features. Vertical scalability is limited by hardware. Replication doesn't provide scalability in read-write performance and database size. Only sharding promises this.
However, such a brilliant feature is hard to implement. And here is the point where different community parties should work together. The PostgreSQL community has done a great work on foreign data wrappers and continues improving them. Postgres Pro has experience in distributed transactions, snapshots and query planning/execution.
In this talk we will cover existing advances in sharding and present a roadmap of transforming them into a comprehensive sharding solution suitable for the main use cases.
Анна Акентьева
Программист-разработчик компании Postgres Professional
ДокладThe present and future of vacuum and autovacuum
In this talk we will have a look at the details of vacuum/autovacuum's implementation and see what kind of practical implications they have. The talk will also provide an overview of patches for vacuum and autovacuum that are currently being considered by the developer community and that may be included in newer versions of PostgreSQL.
Никита Глухов
программист-разработчик Postgres Professional
Олег Бартунов
соучеридитель и генеральный директор компании Postgres Professional,
PostgreSQL Major Contributor
Jsonpath in examples and its roadmap
PostgreSQL 12 introduced a jsonpath - the query language for json, which is an important part of SQL/JSON specification in SQL-2016 standard. Jsonpath is a flexible way to specify the parts of json to be used for processing in functions and operators. The language being very rich is quite complex and we will demonstrate how it works using examples from simple to complex quieries. Also, we will explain how indexes works for jsonpath and show the performance benefits of using jsonpath and old arrow operators.
We will present the roadmap for PostgreSQL 13 and further releases.
