Latest Episodes
396
600 Times Faster Analytics | Scaling Postgres 396
In this episode of Scaling Postgres, we discuss using Postgres queries in ClickHouse, faster faceted search, max_connections & migrations and different scan types. To...
395
16 Times Faster Join Plans | Scaling Postgres 395
In this episode of Scaling Postgres, we discuss a patch that can plan joins 16 times faster, the best way to record text values,...
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...