Scaling Postgres

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-hood/

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/