Percona Transparent Data Encryption for PostgreSQL (pg_tde) is an open-source PostgreSQL extension that provides Transparent Data Encryption (TDE) to protect data at rest. pg_tde ensures that data stored on disk is encrypted and cannot be…
PostgreSQL solves a bootstrapping puzzle with `data_directory`: how to find the config file before knowing where the data lives.

I shared a chart, in 2022, showing where PostgreSQL contributor gifts are mailed to. Here's an updated chart (click to zoom in.) To quickly recap: the PostgreSQL community has been sending gifts to those who contribute directly to a new…
Learn why PostgreSQL reads 16x more data than your queries need, and how a hybrid row-columnar storage layout eliminates the bottleneck without changing your SQL.