A free weekly show on how to scale your PostgreSQL relational database.
Keep current on relevant Postgres content from around the web.
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.