Latest Episodes
104
Reducing WAL, What is Null?, Understanding SQL, TPC-H Benchmarking | Scaling Postgres 104
In this episode of Scaling Postgres, we discuss how to reduce the size of your WAL files, what is null, how to better understand...
103
Scaling Out, Planner Estimation, Create Statistics, Stay Curious | Scaling Postgres 103
In this episode of Scaling Postgres, we discuss how to scale out, how the planner estimates, uses of create statistics and investigating PostgreSQL run...
102
UUID Use Cases, pg_settings, Automated Restore, Parallel Future | Scaling Postgres 102
In this episode of Scaling Postgres, we discuss the use cases for UUIDs, using pg_settings, setting up an automated restore and the future of...
101
Postgres Releases, Useless Vacuum, Isolation Differences, WAL Compression | Scaling Postgres 101
In this episode of Scaling Postgres, we discuss new postgres releases, useless vacuuming, isolation differences between databases, and different ways to compress WAL files....
100
Full Text Search, Query Optimization, Exception Blocks, Procedural Language | Scaling Postgres 100
In this episode of Scaling Postgres, we discuss full text search, a process for query optimization, caution with exception blocks and adding a procedural...
99
Ballad of Bloat, Auditing Options, Configuration Options, Need Vacuum? | Scaling Postgres 99
In this episode of Scaling Postgres, we discuss the "Ballad of Bloat", options for auditing, a configuration help resource and determining when a vacuum...