Latest Episodes
294
How Much Observability Is Needed? | Scaling Postgres 294
In this episode of Scaling Postgres, we discuss how much observability is needed, avoiding locks during database migrations, a huge Postgres events blogging event...
293
Better Plans With Statistics | Scaling Postgres 293
In this episode of Scaling Postgres, we discuss how create statistics can help you get better plans, issues with subtransactions, all about extensions and...
292
Companion Databases? | Scaling Postgres 292
In this episode of Scaling Postgres, we discuss using companion databases, multi-tenancy database design, whether SQL is good, and different transaction isolation levels. To...
291
2 To 4 Times Faster With Vectorization | Scaling Postgres 291
In this episode of Scaling Postgres, we discuss Timescale's performance improvements from adding a query vectorization pipeline, doing blue-green deployments for databases, using reserved_connections...
290
Postgres Releases = Reindexing | Scaling Postgres 290
In this episode of Scaling Postgres, we discuss my Postgres Performance Starter Kit, new releases of Postgres, removing JIT, and a lightweight message queue....
289
Postgres Scheduling Opportunities | Scaling Postgres 289
In this episode of Scaling Postgres, we discuss new options for Postgres scheduling tools, proper ways to kill processes and explain usage. To get...