Overhead of pg_stat_statements | Scaling Postgres 304

In this episode of Scaling Postgres, we discuss the overhead of using pg_stat_statements, DBA use of logs, an RDS migration success, and some Postgres best practices.

Content Discussed

• Overhead of pg_stat_statements and pg_stat_kcache
• Logging: What, Why and When
• A story of a spectacular success - Intro to AWS RDS database migration series
• FOSSCOMM 2023 Heraklion — How PostgreSQL can help you enforce best practices
• SQL Optimization: a comprehensive developer’s guide
• Last Updated Columns With Postgres
• Moving local settings for pg_hba.conf and postgresql.conf out of PGDATA
• An Efficient Way to Check for Existence of Multiple Values in SQL
• Out of range planner statistics and "get_actual_variable_range" in Postgres
• RFC: Extension Metadata Typology
• Functions and Procedures: Learning PostgreSQL with Grant
• Maintainable Podcast — Maintainable…Databases?
• Getting Started with pgBackRest: Perform Your First Backup
• PostgreSQL 17: transaction_timeout
• Selective Column Replication in PostgreSQL
• PgBouncer: The one with prepared statements
• PostgreSQL to Microsoft Excel via Npgsql
• CFP / Call for Proposals
• FOSDEM and FOSDEM PGDay 2024 Review
• Amazon Aurora vs. RDS: Understanding the Difference
• The Builders Podcast Recap: Unlocking Postgres Power: A Deep Dive on Simplifying High Availability with Gianni Ciolli
• Fan-out from Postgres with Change Data Capture using Debezium and Upstash Redis
• PostgreSQL Tuning and DBtune
• Postgres to ClickHouse Real time Replication using PeerDB

YouTube Video

Podcast Audio