Scaling Postgres

In this episode of Scaling Postgres, we discuss how too many columns in a table can affect performance, at what point BRIN indexes win over btree, and Postgres 15 supporting unique nulls and parallel distinct queries. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/224-column-performance-brin-win-unique-null-parallel-distinct/

In this episode of Scaling Postgres, we discuss the process of decomposing your database, how to search text in Postgres quickly, how to understand the output of pg_stat_activity and how to use window functions to solve a use case. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/223-database-decomposition-fast-text-search-understanding...

In this episode of Scaling Postgres, we discuss psql shortcuts, how to debug deadlocks, how to find & stop queries and how to understand and use SCRAM authentication. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/222-postgres-15-beta-2-concerning-locks-vacuum-tuning-transaction-anomalies/

In this episode of Scaling Postgres, we discuss psql shortcuts, how to debug deadlocks, how to find & stop queries and how to understand and use SCRAM authentication. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/221-psql-shortcuts-debugging-deadlocks-find-and-stop-queries-using-scram/

In this episode of Scaling Postgres, we discuss a PG 14.4 release, how to skip transactions with logical replication, how to use schemas and Citus going fully open source. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/220-pg-14.4-release-subscription-skip-using-schemas-open-source-citus/

In this episode of Scaling Postgres, we discuss a Postgres 14 out-of-cycle release next week, whether you should upgrade, the state of Postgres survey and a tool for automatic indexing. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/219-out-of-cycle-release-should-you-upgrade-state-of-postgres-survey-automatic-indexing/

In this episode of Scaling Postgres, we discuss a severe bug with index creation in Postgres 14, view permissions options, dealing with logical replication conflicts and looking under the hood of AlloyDB. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/214-pg14-index-bug-view-permissions-logical-replication-conflicts-alloydb-under-the-...

In this episode of Scaling Postgres, we discuss mistakes you can make when doing schema changes, how best to cancel statements, looking into pg_rman, and looking at a pedantry removal. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/217-schema-change-mistakes-canceling-statements-pg_rman-pedantry-removal/

In this episode of Scaling Postgres, we discuss the Beta 1 release of Postgres 15, optimizing a query by breaking it down, improvements to sort performance and prepared statements for partitioned tables. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/216-pg15-beta1-release-query-breakdown-sort-performance-prepared-vs-partitioned/

In this episode of Scaling Postgres, we discuss parallel server-side backup compression, IO in Postgres, parquet files and the new pg_stat_monitor extension. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/215-new-releases-alloydb-time-zones-connecting-to-postgres/

In this episode of Scaling Postgres, we discuss parallel server-side backup compression, IO in Postgres, parquet files and the new pg_stat_monitor extension. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/214-backup-compression-postgres-io-parquet-files-pg_stat_monitor/

In this episode of Scaling Postgres, we discuss ways you can optimize the planner, becoming part of the Postgres Community, considerations for large databases and mapping three different types of spatial data. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/213-planner-optimization-fish-to-elephants-large-databases-spatial-data/

In this episode of Scaling Postgres, we discuss dealing with slow queries, upgrading a 4TB database, running Postgres on ZFS and handling a storage stampede. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/212-slow-queries-4tb-upgrade-postgres-on-zfs-storage-stampede/

In this episode of Scaling Postgres, we discuss working with multiranges, missing Postgres metrics, PostGIS for newbies and videos from CitusCon. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/211-mutiranges-missing-metrics-newbie-postgis-conference-videos/

In this episode of Scaling Postgres, we discuss how to bin date times, search every field of a table, use JSON_TABLE and methods for a client to pick the primary database. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/210-date-time-bins-search-every-field-json_table-picking-primary/

In this episode of Scaling Postgres, we discuss how to optimize vacuum, how to drop roles, the new merge command in PG15 and a pgbouncer tutorial. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/209-tidy-vacuum-dropping-roles-merge-command-pgbouncer-tutorial/

In this episode of Scaling Postgres, we discuss a new version of pgbouncer, query parameter types, a performance improvement from a lateral join and security invoker views. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/208-pgbouncer-released-query-parameter-types-lateral-joins-security-invoker-views/

In this episode of Scaling Postgres, we discuss how best to configure autovacuum, the dangers of duplicate key violations, how to set up pipelining, and how to tune max_wal_size. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/207-autovacuum-configuration-dupliate-key-violations-pipelining-tuning-max_wal_size/

In this episode of Scaling Postgres, we discuss 100x optimizations, how to audit table activity, designing schemas and how to set up table checksums. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/206-100x-optimizations-auditing-document-schema-designs-checksums/

In this episode of Scaling Postgres, we discuss the best ways to index with tsearch, what to check if tuples are not yet removable, wicked problems with Postgres and different pattern matching techniques. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/205-indexing-with-tsearch-tuples-not-yet-removable-wicked-problems-pattern-matching/

In this episode of Scaling Postgres, we discuss optimizing trigram searches, a review of Postgres replication, improvements to logical replication and a significant Timescale investment. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/204-optimizing-trigram-search-replication-review-logical-improvements-timescale-investment/

In this episode of Scaling Postgres, we discuss the new releases of Postgres, a hairy upgrade incident, why slowing down can make you go faster and using loadable modules for WAL archiving. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/203-saving-space-working-with-toast-protecting-data-high-cpu-utilization/  

In this episode of Scaling Postgres, we discuss the new releases of Postgres, a hairy upgrade incident, why slowing down can make you go faster and using loadable modules for WAL archiving. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/202-new-postgres-releases-hairy-incident-slow-down-to-go-faster-loadable-module-archiving/

In this episode of Scaling Postgres, we discuss JSONB performance, bidirectional replication, getting the most recent record and using JSON in Postgres 14. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/201-jsonb-performance-bidirectional-replication-most-recent-record-pg14-json/  

In this episode of Scaling Postgres, we discuss the new series 5 minutes of Postgres, using unnest, switching to SCRAM authentication and reviewing multi-master solutions. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/200-5-minute-postgres-unnest-scram-multi-master-review/