PostgreSQL Europe 2018
Конференция PostgreSQL Europe является крупнейшей конференцией PostgreSQL в Европе.
Конференция этого года - 10-я ежегодная конференция PostgreSQL Europe. Конференция организована сообществом PostgreSQL Europe с участием большинства других сообществ пользователей и разрабочиков PostgreSQL. Она призвана стать важным местом для встречи и сотрудничества пользователей PostgreSQL как в Европе, так и за ее пределами.
PGConf.EU - уникальная возможность для европейских пользователей и разработчиков PostgreSQL быть в курсе новых разработок, учиться, строить отношения с коллегами и партнерами, узнавать друг друга и приобщаться к обществу профессионалов, которые используют и работают с PostgreSQL.
Мероприятие каждый год перемещается между крупнейшими городами Европы. В 2018 году конференция PostgreSQL Europe проводится в столице Португалии - в городе Лиссабон.
В программе конференции
Олег Бартунов
Компания Postgres Professional
Генеральный директор, основатель компании
Тема доклада
«Do you need a full-text search in PostgreSQL?»
Full-Text Search ( FTS ) is a search for the documents, which satisfy query and, optionally, return them in some order. Most usual case is to find documents containing all query terms and return them in order of their similarity to the query. Notions of query and similarity are very flexible and depend on specific applications.
I will explain why do you need a built-in FTS, while there are many off-database solutions like Solr, Sphinx or Elastic Search. Also, I will present a state of art FTS in PostgreSQL, including new features like phrase search, web query, RUM index and new ranking function, better flexible FTS configuration and discuss a development roadmap.
Слайды:
Анастасия Лубенникова
Компания Postgres Professional
программист-разработчик
Тема доклада
«Advanced PostgreSQL Backup and Recovery methods»
As database size and complexity grow, DBAs may face the fact that the functionality offered by built-in tools such as pg_dump and pg_basebackup is insufficient, and more flexibility is required to create reliable backups.
In this talk, I'll cover various advanced topics in the area of backups - incremental backups - archive management - PITR - backup validation - compression and encryption - retention policies, etc.
Based on this, we'll look at various backup/recovery solutions. This information will help you to choose the most appropriate tool for your system.
Слайды:
Александр Кузьменков
Компания Postgres Professional
Старший разработчик
Тема доклада
«Towards more efficient query plans: PostgreSQL 11 and beyond»
A major responsibility of a database engine is to convert a declarative SQL query to an efficient execution plan, employing various methods to scan and join the relations. There is always a development effort to improve this area. What clever execution plans can PostgreSQL generate, what's new in version 11 and what is in development? To name a few things, the joins are optimized by removing unneeded outer and inner joins, and reducing joins from outer and semi to inner. There is work to enable merge joins on inequality and range overlap, and to improve join selectivity estimates with multi-column statistics. When it comes to scanning a single relation, covering indexes allow to use index-only scans more often. Incremental sort and more precise estimation of sorting costs help generate better paths when sorted output is required, e.g. when using GROUP BY and ORDER BY or performing merge joins. This talk aims to give an overview of such optimizations that already exist and that are being developed now.