Data Directory, Vacuum Features, Binary Performance, Network Latency | Scaling Postgres 114

In this episode of Scaling Postgres, we discuss the Postgres data directory, new vacuum features, binary storage performance and the impact of network latency.

Content Discussed

• PostgreSQL 12.3, 11.8, 10.13, 9.6.18, and 9.5.22 Released!
• yum users: some -devel RPMs require a new repository
• Postgres Distinct On
• Don't Manually Modify The PostgreSQL Data Directory!
• Improved (auto)vacuum in PostgreSQL 13
• Binary data performance in PostgreSQL
• PostgreSQL: Network latency does make a BIG difference
• Overcoming Impostor Syndrome: Working with PostgreSQL's SSL Modes
• Benefits of External Key Management System Over the Internal and How they Could Help Securing PostgreSQL
• Keep your libraries updated and nobody gets hurt
• Multicolumn Partitioning
• PgBadger: X-Ray Vision for Your Queries
• Key Parameters and Configuration for Streaming Replication in Postgres 12
• Fuzzy Searching with PostgreSQL
• Advanced SQL and database books and resources
• Build PostgreSQL and Extension on Windows
• Fabrízio de Royes Mello

YouTube Video

Podcast Audio