This webinar will cover the features and enhancements included in the latest release of PostgreSQL, the world’s most advanced open source database. A hacker’s look pre-assumes going beyond just naming all features - we’ll take a deep dive into how they work and where they can be used. Our virtual event will explain what can be achieved with the following PostgreSQL 13 enhancements:

- B-tree deduplication for index size reduction;

- major performance-related improvements: incremental sorting, hash aggregation, and parallelized vacuum for indexes;

- enhanced partitioning functionality;

- administration, development, and security improvements.

In addition to this, we will dig into some specific features and stories behind their development.

- Why index deduplication can be useful for unique indexes, too?

- What steps were made towards future bigger features and even better extensibility?

If you want to make the most of “the baker’s dozen”, join us - this event is free to attend.

Speaker Bio: Anastasia Lubennikova

Anastasia Lubennikova, a PostgreSQL contributor, educator and evangelist, works for Postgres Professional, where she specializes in PostgreSQL index access methods, backup solutions and data structures. Anastasia has been involved in PostgreSQL-related projects as a developer and industry speaker for more than five years. In 2020 she joined PostgreSQL’s Code of Conduct Committee.

Doing double duty as a DBMS developer and support engineer, Anastasia works on the Postgres Pro database and contributes to the original PostgreSQL core. She implements both community and enterprise projects, connecting the art of system development with real business needs. In February 2020, Anastasia announced that the B-tree index deduplication feature she developed with Peter Geoghegan has been committed to PostgreSQL 13. This feature, which enables index size reduction of up to 3 times, has been available to Postgres Pro Enterprise users since version 10.

Prior to joining Postgres Professional, Anastasia worked on PostgreSQL during Google Summer of Code 2014, and PostgreSQL was the primary focus of her graduation thesis. Anastasia also authored her own “Hacking PostgreSQL” course covering various components and subsystems of this DBMS. She holds a Bachelor of Science in Applied Mathematics and Information Science from NRNU MEPhI.