Scaling Postgres

In this episode of Scaling Postgres, we review articles covering PG11 sharding, giving back, SCRAM authentication and the evolution of partitioning. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/36-sharding-giving-back-scram-partitioning-evolution/

In this episode of Scaling Postgres, we review articles covering terabyte scaling, PostgreSQL 11, managing connections and backup of terabyte databases. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/35-terabyte-scaling-postgres-11-connections-backup/

In this episode of Scaling Postgres, we review articles covering all about inserts, how to handle nearest neighbor, freezing confirmation and Comment. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/34-inserts-nearest-neighbor-freezing-comment/

In this episode of Scaling Postgres, we review articles covering per-table autovacuum, FDW for data synchronization, distinct on and Postgres Open. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/33-per-table-autovacuum-fdw-synchronization-distinct-on-postgres-open/

In this episode of Scaling Postgres, we review articles covering sysadmin concerns, the power of indexing, pgbouncer monitoring and pg_prewarm. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/32-sysadmin-concerns-power-of-indexing-pgbouncer-monitoring/

In this episode of Scaling Postgres, we review articles covering a CTE warning, Postgres 11 new features, death by database and column correlation. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/31-cte-warning-pg11-features-death-by-db-column-correlation/

In this episode of Scaling Postgres, we review articles covering parallellism in Postgres 11, JIT compiling, indexes in depth and administration. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/30-parallelism-jit-compiling-indexes-administration/

In this episode of Scaling Postgres, we review articles covering parallel indexing, SQL vs. ORM, logical replication upgrades and development DBs. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/29-parallel-indexing-sql-vs-orm-logical-replication-upgrades/

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/

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/

In this episode of Scaling Postgres, we review articles covering using Postgres for real-time analytics, how indexes can decrease performance and how to configure work_mem. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/17-real-time-analytics-index-decrease-performance-work_mem/

In this episode of Scaling Postgres, we review articles covering efficiently storing bits, autovacuum, setting up assertions and logical replication recovery. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/16-storing-bits-autovacuum-assertions-logical-recovery/

In this episode of Scaling Postgres, we review articles on how to better leverage postgres, tuning autovacuum, handling slow queries and using window functions. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/15-leveraging-postgres-tuning-autovacuum-slow-queries/

In this episode of Scaling Postgres, we review articles covering the upcoming PostgreSQL 11, scaling for multi-tenant apps, the speed of triggers and full text search. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/14-pg11-multi-tenant-scale-trigger-speed-full-text-search/

In this episode of Scaling Postgres, we review articles covering the future of sharding PostgreSQL databases, query optimization, replication read performance and PostGIS. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/13-shardings-future-query-optimization-replication-read-performance-postgis/

In this episode of Scaling Postgres, we review articles covering the future of databases, why counting is slow, the best ways to avoid ORs, and all about replication. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/12-future-slow-counts-avoid-or-replication/

In this episode of Scaling Postgres, we review articles covering serializable, JSON & JSONB data types, fast data loading with Ruby and Postgres 11 new features. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/11-serializable-json-jsonb-fast-data-loading-pg11-features/

In this episode of Scaling Postgres, we review articles covering ANSI Schmansi, split-brain replication issues, performance solutions to business scenarios and paralellism. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/10-ansi-schmansi-split-brain-performance-scenarios-parallelism/

In this episode of Scaling Postgres, we review articles covering high volume processing, indexing, pg_wal issues, Postgres data types and restoring when using pg_receivewal. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/9-high-volume-processing-pg_wal-issues-restore-pg_receivewal/

In this episode of Scaling Postgres, we review articles covering real-time analytics at scale, covering indexes in Postgres 11, 1,500 Postgres upgrades and PostgreSQL vs. MySQL. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/8-scaling-analytics-covering-indexes-1500-upgrades/

In this episode of Scaling Postgres, we review articles covering Postgres at any scale, monitoring vacuum, using copy, annotated config files, and how to do easy replication failback to an old primary database. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/7-any-scale-monitor-vacuum-copy-annotated-config/

In this episode of Scaling Postgres, we review articles covering terabyte scale & analytics, database permissions, fast column adding coming to PosgreSQL 11 and pgBouncer. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/6-terabyte-scale-permissions-fast-column-add-pgbouncer/

In this episode of Scaling Postgres, we review articles covering database constraints, user defined ordering, how PostgreSQL is terrible, TimeScaleDB and using logical replication for upgrades. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/5-constraints-user-order-pg-terrible-logical-upgrades/

In this episode of Scaling Postgres, we review articles covering developers loving PostgreSQL, a 50TB database upgrade, information on vacuums, patches for parallel PostGIS plans, database security concerns, DB normalization and primary keys and generate series. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/4-50TB-upgrade-vacuum-db-security/

In this episode of Scaling Postgres, we review articles covering modeling, checking for long queries using pg_stat_statements, statistics in PosgreSQL 10 and pgmetrics. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/3-modeling-query-performance-statistics-pgmetrics/

In this episode of Scaling Postgres, we review articles covering analytical DBs (potentially using GPUs), recursive queries and different forms of replication. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/2-analytical-db-recursive-queries-replication/

In this episode of Scaling Postgres, we review articles covering petabyte scale techniques as well as various articles on locking. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/1-petabyte-scale-and-locking/