Scaling Postgres Episodes
Episodes on how best to scale your PostgreSQL relational database.
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.
Scaling Postgres Episode 147 DBMS of the Year | Better Data Migrations | Idle Connection Impact | Security Implementation Guide
In this episode of Scaling Postgres, we discuss PostgreSQL as the DBMS of the year, running better data migrations, the impact of idle connections and a security implementation guild.
Scaling Postgres Episode 146 Active-Active & Federated | Memory Speed | Table Rewrite Causes | PostgreSQL Shibboleth
In this episode of Scaling Postgres, we discuss setting up active-active instances with federation, the impact of memory speed, the causes of table rewrites and the Postgres shibboleth.
Scaling Postgres Episode 145 PgMiner Botnet | Collation Index Corruption | postgresql.conf | Custom Data Types
In this episode of Scaling Postgres, we discuss the PGMiner botnet attack, how collation changes can cause index corruption, managing your postgresql.conf and implementing custom data types.