Latest Episodes
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...
13
Sharding Future, Query Optimization, Replication Read Performance, PostGIS | Scaling Postgres 13
In this episode of Scaling Postgres, we review articles covering the future of sharding PostgreSQL databases, query optimization, replication read performance and PostGIS. To...
12
The Future, Slow Counts, Avoid Or, Replication | Scaling Postgres 12
In this episode of Scaling Postgres, we review articles covering the future of databases, why counting is slow, the best ways to avoid ORs,...