Latest Episodes
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...
20
Declarative Partitioning, Permissions, Trigger Speed | Scaling Postgres 20
In this episode of Scaling Postgres, we review articles covering declarative partitioning, handling permissions to view data, and the speed of triggers. To get...
19
100K Tenants, Extensions, Query Planning, Crosstabs | Scaling Postgres 19
In this episode of Scaling Postgres, we review articles covering 100,000 tenants, Postgres Extensions, query planning and how to create crosstabs. To get the...