Latest Episodes
394
5 Times Faster Aggregates | Scaling Postgres 394
In this episode of Scaling Postgres, we discuss my Black Friday / Cyber Monday course deal, the job security that LLMs provide, new Postgres...
393
Job Security? | Scaling Postgres 393
In this episode of Scaling Postgres, we discuss my Black Friday / Cyber Monday course deal, the job security that LLMs provide, new Postgres...
392
100 Times Faster By Skipping! | Scaling Postgres 392
In this episode of Scaling Postgres, we discuss performance improvements related to skip scans, faster backup & restore, benefits of minimal indexes and more...
391
Table Lock Explosion! | Scaling Postgres 391
In this episode of Scaling Postgres, we discuss the issues of partition locking during planning, the problem of too much memory, the importance of...
390
1.2 Million Messages Per Second | Scaling Postgres 390
In this episode of Scaling Postgres, we discuss how far Postgres can scale with queue and pub/sub workloads, temporal joins, IPC:SyncRep and nested partitioning....
389
Heavy Reader or Writer? | Scaling Postgres 389
In this episode of Scaling Postgres, we discuss ways to optimize reading or writing, the benefits of a descending index, more information about lightweight...