Latest Episodes
19
100K Tenants, Extensions, Query Planning, Crosstabs | Scaling Postgres 19
In this episode of Scaling Postgres, we review articles covering 100,000 tenants, Postgres Extensions, query planning and how to create crosstabs. To get the...
18
Impact of Virtualization, Compressing Data, Parallelism | Scaling Postgres 18
In this episode of Scaling Postgres, we review articles covering the impact of virtualization on databases, techniques to compress your data and parallelism. To...
17
Real Time Analytics, Index Decrease Performance, work_mem | Scaling Postgres 17
In this episode of Scaling Postgres, we review articles covering using Postgres for real-time analytics, how indexes can decrease performance and how to configure...
16
Storing Bits, Autovacuum, Assertions, Logical Recovery | Scaling Postgres 16
In this episode of Scaling Postgres, we review articles covering efficiently storing bits, autovacuum, setting up assertions and logical replication recovery. To get the...
15
Leveraging Postgres, Tuning Autovacuum, Slow Queries | Scaling Postgres 15
In this episode of Scaling Postgres, we review articles on how to better leverage postgres, tuning autovacuum, handling slow queries and using window functions....
14
Postgres 11, Multi-tenant Scale, Trigger Speed, Full Text Search | Scaling Postgres 14
In this episode of Scaling Postgres, we review articles covering the upcoming PostgreSQL 11, scaling for multi-tenant apps, the speed of triggers and full...