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 153 Int to BigInt | Resistance is Futile | Optimizer Statistics | Advanced Query Optimization
In this episode of Scaling Postgres, we discuss how to convert an integer primary key to a bigint, how container resistance is futile, how the optimizer uses statistics and how to set manual statistics.
Scaling Postgres Episode 152 New Releases | Reconnect After Failure | Bablefish | Troubleshoot Disk & Memory
In this episode of Scaling Postgres, we discuss new PostgreSQL releases, reconnecting after a connection failure, Babelfish SQL Server compatibility and troubleshooting disk and memory issues.