| PGConf.EU 2019

Даты:

PGConf.EU 2019 – Крупнейшая европейская конференция по PostgreSQL

Крупнейшая в Европе конференция посвященная СУБД PostgreSQL. Проводится ежегодно и каждый год в каком-то новом городе. До сих пор выбранные для конференции города не повторялись. Но в этом году конференция вновь проводится в Италии - в стране, в которой проводилась в самый первый раз. В 2019 году конференция PGConf.EU проводится уже в 11-й раз, в Милане.

В программе конференции

Фёдор Сигаев, Технический директор компании Postgres Professional, PostgreSQL Major Contributor & PostgreSQL Committer

Фёдор Сигаев

технический директор 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

Александр Коротков

главный архитектор СУБД 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

Александр Коротков

главный архитектор СУБД Postgres Professional
PostgreSQL Major Contributor & PostgreSQL Committer

 
Bruce Momjian, co-founder of the PostgreSQL Global Development Group, Senior Database Architect in EDB, Community Contributors

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

Анна Акентьева

Программист-разработчик компании 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

 
Олег Бартунов, соучеридитель и генеральный директор компании Postgres Professional, PostgreSQL Major Contributor

Олег Бартунов

соучеридитель и генеральный директор компании 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.

ПОДРОБНЕЕ

 

САЙТ КОНФЕРЕНЦИИ