Scaling Postgres

By Creston JamisonTechnology

Scaling Postgres episodes

September 03, 2018 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 the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/28-watch-fast-text-search-column-defaults-import-csv/
18 min
August 27, 2018 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 notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/27-multiple-databases-slow-queries-sorting-performance/
19 min
August 20, 2018 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 notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/26-join-costs-zheap-autovacuum-tuning/
10 min
August 13, 2018 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 show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/25-generate_series-pg11-partitioning-gpu-queries/
14 min
August 06, 2018 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 show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/24-full-text-search-jsonb_agg-upgrades-cis/
13 min
July 30, 2018 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 get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/23-uuids-write-spikes-distinct-sql-standard/
15 min
July 23, 2018 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 show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/22-concurrency-listen-notify-zfs-pg_rewind/
12 min
July 16, 2018 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 get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/21-using-json-procedures-concurrency-kubernetes/
20 min
July 09, 2018 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 the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/20-declarative-partitioning-permissions-trigger-speed/
15 min
July 02, 2018 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 show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/19-100k-tenants-extensions-query-planning-crosstabs/
18 min

About Scaling Postgres

From the publisher's feed

Learn how to get the best performance and scale your PostgreSQL database with our weekly shows. Receive the best content curated from around the web. We have a special focus on content for developers…