Latest Episodes
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,...
11
Serializable, JSON & JSONB, Fast Data Loading, PG11 Features | Scaling Postgres 11
In this episode of Scaling Postgres, we review articles covering serializable, JSON & JSONB data types, fast data loading with Ruby and Postgres 11...
10
ANSI Schmansi, Split-Brain, Performance Scenarios, Parallelism | Scaling Postgres 10
In this episode of Scaling Postgres, we review articles covering ANSI Schmansi, split-brain replication issues, performance solutions to business scenarios and paralellism. To get...