Latest Episodes
29
Parallel Indexing, SQL vs. ORM, Logical Replication Upgrades | Scaling Postgres 29
In this episode of Scaling Postgres, we review articles covering parallel indexing, SQL vs. ORM, logical replication upgrades and development DBs. To get the...
28
Watch, Fast Text Search, Column Defaults, Import CSVs | Scaling Postgres 28
In this episode of Scaling Postgres, we review articles covering watching Star Wars, fast text search, column defaults and importing large CSVs. To get...
27
Multiple Databases, Slow Queries, Sorting Performance | Scaling Postgres 27
In this episode of Scaling Postgres, we review articles covering scaling with multiple databases, detecting slow queries, and sorting performance. To get the show...
26
Join Costs, zHeap, Autovacuum Tuning | Scaling Postgres 26
In this episode of Scaling Postgres, we review articles covering join costs, zHeap, autovacuum tuning and Postgres configuration for humans. To get the show...
25
generate_series, PG11 Partitioning, GPU Queries | Scaling Postgres 25
In this episode of Scaling Postgres, we review articles covering graphing with generate_series, partitioning in Postgres 11 and GPUs for queries. To get the...
24
Full Text Search, JSONB_AGG, Upgrades, CIS | Scaling Postgres 24
In this episode of Scaling Postgres, we review articles covering full text search, aggregating JSON with jsonb_agg, upgrades and CIS benchmarks. To get the...