Latest Episodes
218
PG14 Index Bug, View Permissions, Logical Replication Conflicts, AlloyDB Under the Hood | Scaling Postgres 218
In this episode of Scaling Postgres, we discuss a severe bug with index creation in Postgres 14, view permissions options, dealing with logical replication...
217
Schema Change Mistakes, Canceling Statements, pg_rman, Pedantry Removal | Scaling Postgres 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,...
216
PG 15 Beta 1 Release, Query Breakdown, Sort Performance, Prepared vs. Partitioned | Scaling Postgres 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...
215
New Releases, AlloyDB, Time Zones, Connecting to Postgres | Scaling Postgres 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...
214
Backup Compression, Postgres IO, Parquet Files, pg_stat_monitor | Scaling Postgres 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...
213
Planner Optimization, Fish to Elephants, Large Databases, Spatial Data | Scaling Postgres 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...