⇽ Bruce Momjian ⇽

Postgres Pending Features Presentations


What's Missing in Postgres? (no slides yet)

Postgres adds about 200 features and changes every year, yet it is missing some major ones. This talk explains what those features are, and why they have not been implemented. The features include optimizer hints, sharding, cluster file encryption (i.e., tde), global indexes, and multi-master replication.
Duration: 20 minutes, 30 minutes with questions

Cluster File Encryption in Postgres

Cluster file encryption, or Transparent Data Encryption (tde) as it is called in the industry, is the ability of the database to store all user data encrypted in the file system. It prevents users with read access on the database directories from being able to access the data stored in those files, and provides data-at-rest security. This talk explains the general features of cluster file encryption and how it will be implemented soon in Postgres.

The Future of Postgres Sharding

Database sharding involves spreading database contents across multiple servers, with each server holding only part of the database. While it is possible to vertically scale Postgres, and to scale read-only workloads across multiple servers, only sharding allows multi-server read-write scaling. This presentation will cover the advantages of sharding and future Postgres sharding implementation requirements, including foreign data wrapper enhancements, parallelism, and global snapshot and transaction control. This is a followup to my Postgres Scaling Opportunities presentation.
Duration: 30 minutes, 45 minutes with questions