Podcast Episodes

Schema Change Mistakes, Canceling Statements, pg_rman, Pedantry Removal | Scaling Postgres 217

Episode 217

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 sho…

Published on 3 years, 6 months ago

PG 15 Beta 1 Release, Query Breakdown, Sort Performance, Prepared vs. Partitioned | Scaling Postgres 216

Episode 216

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 tab…

Published on 3 years, 7 months ago

New Releases, AlloyDB, Time Zones, Connecting to Postgres | Scaling Postgres 215

Episode 215

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 noti…

Published on 3 years, 7 months ago

Backup Compression, Postgres IO, Parquet Files, pg_stat_monitor | Scaling Postgres 214

Episode 214

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 noti…

Published on 3 years, 7 months ago

Planner Optimization, Fish to Elephants, Large Databases, Spatial Data | Scaling Postgres 213

Episode 213

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 spa…

Published on 3 years, 7 months ago

Slow Queries, 4TB Upgrade, Postgres on ZFS, Storage Stampede | Scaling Postgres 212

Episode 212

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 noti…

Published on 3 years, 7 months ago

Multiranges, Missing Metrics, Newbie PostGIS, Conference Videos | Scaling Postgres 211

Episode 211

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 …

Published on 3 years, 8 months ago

Date Time Bins, Search Every Field, JSON_TABLE, Picking Primary | Scaling Postgres 210

Episode 210

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 we…

Published on 3 years, 8 months ago

Tidy Vacuum, Dropping Roles, Merge Command, PgBouncer Tutorial | Scaling Postgres 209

Episode 209

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…

Published on 3 years, 8 months ago

pgbouncer Released, Query Parameter Types, Lateral Joins, Security Invoker Views | Scaling Postgres 208

Episode 208

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 w…

Published on 3 years, 8 months ago