Přednášky

A look at the Elephant's trunk - PostgreSQL 15 (anglicky)

Magnus Hagander / Redpill Linpro /

PostgreSQL 15 is in feature freeze state, and we have a good idea of which new features will be included. This talk will take a quick look at what's in there, and what to expect from this release scheduled for later this year.

Novinky v BRIN indexech

Tomáš Vondra / EDB /

PostgreSQL podporuje BRIN indexy již od verze 9.5 - jejich hlavní výhoda je brutální úspora místa (uproti klasickým B-Tree indexům), ale současně mají různá omezení a pro některé typy dat / distribuce nemusí fungovat. PostgreSQL 14 a 15 přináší několik zajímavých vylepšení (nové opclass, ignorování HOT, atd.) díky kterým mohou být BRIN indexy použitelné i pro další aplikace.

Logical replication in PostgreSQL is moving forward (anglicky)

Peter Eisentraut / EDB /

forwardLogical replication in PostgreSQL is moving forward. PostgreSQL 15 and beyond will see a variety of new features such as row filtering, sequence replication, and improved error handling. Many more features are in progress for future versions. In this presentation, I want to lay out and discuss our roadmap for logical replication in PostgreSQL.

Topics will include: row filtering, column filtering, sequence replication, schema syncing, error handling, skipping transactions, less reliance on superuser, logical failover, conflict handling, perspectives on pglogical and BDR

There will be a lengthy list of things we plan to work on beyond PostgreSQL 15, and of course we are looking for other community members to join these efforts.

Pokročilá práce v psql

Pavel Stěhule /

psql je textový TUI klient pro práci s PostgreSQL. Na první pohled příliš neoslní, i když ve své kategorii je špička. Obsahuje celou řadu zajímavých funkcí včetně jednoduchého skriptovacího jazyka. Díky podpoře rour, je možné výstup z psql přesměrovat do pageru (ukáži možnosti pspg), je možné výstup z psql přesměrovat do clipboardu nebo si v gnu plotu nechat zobrazit graf. Navíc psql umožňuje tvorbu jednoduchých maker, takže je možné psql mírně rozšiřovat. V prezentaci vysvětlím jak.

Asynchronous query execution in PostgreSQL (anglicky)

Gilles Darold /

This talk will discuss all possible ways to execute queries asynchronously in PostgreSQL. Whether the asynchronous request should be transactional or self-contained, client-side or server-side managed, executed immediately or scheduled on a specific date or periodically, we'll cover all possible solutions.

Izolace transakcí v PostgreSQL

Aleš Zelený / Betsys /

Stručný přehled izolace transakcí v PostgreSQL anomálie, které jsou v souladu se standardem, ale mohou vývojáře překvapit

Aggregates in PGX: An Adventure (anglicky)

James Blackwood-Sewell / Timescale /

PostgreSQL provides a lot of functionality to create custom aggregates, a design feature that’s essential to the success of TimescaleDB. Our users often find themselves wanting to extend and build upon the aggregate functions we provide. However, the prospect of creating a performant aggregate function in C, along with a potential of being the long-term maintainer of a new function, can be a high barrier for many would-be contributors. But there’s great news! Not only does PGX help with creating, testing and deploying aggregates using Rust, it’s easy enough for me to fit the adventure of addressing one GitHub user’s call for help into 40 minutes.

Pro-Active performance analysis in PostgreSQL (anglicky)

Dirk Krautschick / Trivadis /

An everyday task of database administrators is the analysis of performance problems. Often it is just not possible to focus
on a specific fine-grained SQL statement. Most of the time the problems are reported in a state-oriented and imprecise
manner. If the problem cannot simply be reproduced, preventive monitoring and analysis options must be used.

For this purpose, Oracle databases for example are offering with the "Diagnostic Pack" a nice kit of tools and features
for analysing such problems. With the current trend migrating Oracle databases to PostgreSQL, the question
arises again and again if there are equivalent possibilities with PostgreSQL.

This lecture shows how and with which tools or extensions PostgreSQL can preventively prepare for performance problems
and what the conceptual approach of the analysis is in practice.

Of course we are happy to discuss all of this at the end of this session.