Scaling Postgres Episodes
Episodes on how best to scale your PostgreSQL relational database.
Scaling Postgres Episode 172 Per-Operation Explain | PG14 Contributions | Foreign Parallel Execution | Incremental View Maintenance
In this episode of Scaling Postgres, we discuss tracking per-operation explain analyze, Postgres 14 contribution stats, parallel execution on foreign servers and incremental view maintenance.
Scaling Postgres Episode 167 Interpreting Explain Analyze | Bulk Loading Data | Limiting Update & Delete | pg_buffercache
In this episode of Scaling Postgres, we discuss how to interpret explain analyze, the best ways to load data in bulk, how to limit rows affected by update or delete and using pg_buffercache.
Scaling Postgres Episode 164 Fast Random Rows | Fast Distinct Queries | Temp & Unlogged Tables | Terminating Connections
In this episode of Scaling Postgres, we discuss selecting random rows quickly, faster distinct queries, how replication handles temp and unlogged tables and how to terminate connections.
Scaling Postgres Episode 163 SQL Data Analysis | pgBouncer Setup | Understanding Deadlocks | Tuning & Optimization
In this episode of Scaling Postgres, we discuss doing data analysis with SQL, sophisticated pgBouncer set ups, understanding how to avoid deadlocks and an intro to tuning and optimization.