Podcast Episodes
Back to Search
Real Time Analytics, Index Decrease Performance, work_mem | Scaling Postgres 17
Episode 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 work_mem.
To get the show notes as w…
Published on 7 years, 6 months ago
Storing Bits, Autovacuum, Assertions, Logical Recovery | Scaling Postgres 16
Episode 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 show notes as well as get not…
Published on 7 years, 6 months ago
Leveraging Postgres, Tuning Autovacuum, Slow Queries | Scaling Postgres 15
Episode 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.
To get the show notes as well as get n…
Published on 7 years, 6 months ago
Postgres 11, Multi-tenant Scale, Trigger Speed, Full Text Search | Scaling Postgres 14
Episode 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 text search.
To get the show notes as well a…
Published on 7 years, 6 months ago
Sharding Future, Query Optimization, Replication Read Performance, PostGIS | Scaling Postgres 13
Episode 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 get the show notes as we…
Published on 7 years, 7 months ago
The Future, Slow Counts, Avoid Or, Replication | Scaling Postgres 12
Episode 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, and all about replication.
To get the show notes as well as…
Published on 7 years, 7 months ago
Serializable, JSON & JSONB, Fast Data Loading, PG11 Features | Scaling Postgres 11
Episode 11
In this episode of Scaling Postgres, we review articles covering serializable, JSON & JSONB data types, fast data loading with Ruby and Postgres 11 new features.
To get the show notes as well as get …
Published on 7 years, 7 months ago
ANSI Schmansi, Split-Brain, Performance Scenarios, Parallelism | Scaling Postgres 10
Episode 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 the show notes as w…
Published on 7 years, 7 months ago
High Volume Processing, pg_wal Issues, Restore with pg_receivewal | Scaling Postgres 9
Episode 9
In this episode of Scaling Postgres, we review articles covering high volume processing, indexing, pg_wal issues, Postgres data types and restoring when using pg_receivewal.
To get the show notes as …
Published on 7 years, 7 months ago
Scaling Real-Time Analytics, Covering Indexes, 1,500 Upgrades | Scaling Postgres 8
Episode 8
In this episode of Scaling Postgres, we review articles covering real-time analytics at scale, covering indexes in Postgres 11, 1,500 Postgres upgrades and PostgreSQL vs. MySQL.
To get the show notes…
Published on 7 years, 8 months ago