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/

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/

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/

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/

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/

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/

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/

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/

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/

In this episode of Scaling Postgres, we review articles covering the impact of virtualization on databases, techniques to compress your data and parallelism.

To get the show notes as well as get notified of new episodes, visit: 

https://www.scalingpostgres.com/episodes/18-impact-virtualization-compressing-data-parallelism/