Back To Schedule
Tuesday, June 25 • 3:20pm - 4:05pm
New Developments in Pluggable Storage in PostgreSQL

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

For PostgreSQL 12, the PostgreSQL developers, including Andres Freund, have worked hard at making table storage pluggable, i.e. allowing to store table data in different forms than PostgreSQL's current heap.

The goal of this work so is mainly twofold: First, to be able to address new use cases that PostgreSQL's current storage is not well suited for (e.g. columnar stores for analytics workloads). Second, to be able to make architectural changes to even better handle workloads PostgreSQL is already widely used for (e.g. to reduce problems with VACUUM and increase storage density.

In addition to the reasons for making Postgres' table storage pluggable, the talk will give a brief overview over the new API, explain what types of table stores can already be implemented using it,  and what types are not yet possible, and how the limitations of the API prevent the latter can be addressed in future versions of PostgreSQL.

avatar for Andres Freund

Andres Freund

PostgreSQL Developer & Committer, Senior Database Architect, EnterpriseDB
Andres Freund is one of the leading contributors in the Postgres community and his work has been influential to advancing the replication, performance and scalability capabilities of Postgres. He joins EDB from Citus Data, Inc., where he was a Developer and Principal Software Engineer... Read More →

Tuesday June 25, 2019 3:20pm - 4:05pm EDT
Back Bay C The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199