Latest Episodes
296

State Of Postgres 2023 | Scaling Postgres 296
In this episode of Scaling Postgres, we discuss the State of Postgres 2023 survey, a repository of Postgres how-tos, ways foreign keys can break...
295

30K Messages Per Second Queue | Scaling Postgres 295
In this episode of Scaling Postgres, we discuss a 30K messages per second queue built on Postgres, a zero downtime logical replication upgrade, the...
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...