Latest Episodes
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...
23
UUIDs, Write Spikes, Distinct, SQL Standard | Scaling Postgres 23
In this episode of Scaling Postgres, we review articles covering UUIDs, the source of write spikes, uses of distinct and SQL standards support. To...
22
Concurrency, Listen & Notify, ZFS, pg_rewind | Scaling Postgres 22
In this episode of Scaling Postgres, we review articles covering concurrency, how to use listen & notify, zfs, caution regarding pg_rewind. To get the...
21
Using JSON, Procedures, Concurrency, Kubernetes | Scaling Postgres 21
In this episode of Scaling Postgres, we review articles covering how to use JSON & JSONB, procedures, deal with concurrency issues and Kubernetes. To...