11K Faster Configuration Change | Scaling Postgres 305

In this episode of Scaling Postgres, we discuss one configuration change that resulted in an 11,000 times faster query, why Postgres is not using your index, backported PG improvements and parallelism with TOAST.

Content Discussed

• 100x Faster Query in Aurora Postgres with a lower random_page_cost
• Why isn't Postgres using my index?
• Quick Benchmark: PostgreSQL 2024Q1 Release Performance Improvements
• TOAST and its influences on parallelism in PostgreSQL
• The default value of fdw_tuple_cost was updated to 0.2. What does that mean?
• First Row of Many Similar Ones
• 11 Lessons to learn when using NULLs in PostgreSQL
• Uncovering and Exploring ROW Constructors in PostgreSQL
• Prepared statements for psql operations
• The Rest is History: Investigations of WAL History Files
• Maximizing Microservice Databases with Kubernetes, Postgres, and CloudNativePG
• Understand Indexes in pgvector
• Multiple Client Certificate Selection – a Simple POC
• Changes to PGSQL Phriday Blogging Events
• PostgreSQL 17: transaction_timeout
• Recent PGXN Improvements
• The History and Future of Extension Versioning
• Extension Ecosystem Summit 2024
• The Jobs to be Done by the Ideal Postgres Extension Ecosystem
• Speeding up partial COUNT(*) in Postgres by using LIMIT in a subquery
• TDE: A dive into encrypted data
• AUTOCOMMIT – Oracle vs PostgreSQL
• PostgreSQL Backup and Recovery Management using Barman
• pgagroal 1.6.0 has been released
• The azure_ai extension to Azure Database for PostgreSQL, definition and demo
• Autoscaling in Action: Postgres Load Testing with pgbench
• Point In Time Recovery Under the Hood in Serverless Postgres

YouTube Video

Podcast Audio