Latest Episodes
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...
18
Impact of Virtualization, Compressing Data, Parallelism | Scaling Postgres 18
In this episode of Scaling Postgres, we review articles covering the impact of virtualization on databases, techniques to compress your data and parallelism. To...