Latest Episodes
109
Show Plans, WAL Monitoring, Using UUIDs, Default Logging | Scaling Postgres 109
In this episode of Scaling Postgres, we discuss how to show live plans, how Postgres 13 allows WAL monitoring, how to use UUIDs in...
108
Ten Things, Audit Triggers, Schema Design, High Availability | Scaling Postgres 108
In this episode of Scaling Postgres, we discuss ten things to hate about Postgres, audit trigger performance, designing a schema and the future of...
107
Showing Plans, Atomic, Configuration, Migrations | Scaling Postgres 107
In this episode of Scaling Postgres, we discuss how to show live query plans, the importance of atomic operations for scaling out, configuration options...
106
Recursive CTEs, DB Access Patterns, Dates & Times, Cluster | Scaling Postgres 106
In this episode of Scaling Postgres, we discuss how to use recursive CTEs, database access patterns, using dates and times and how to cluster...
105
World's Best, Subtransactions, Sharding, Schema Changes | Scaling Postgres 105
In this episode of Scaling Postgres, we discuss how Postgres is the world's best database, performance ramifications of subtransactions, the current state of sharding...
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...