Subquery Performance, Avoid Update Locking, Column Changes, Outage Workshop | Scaling Postgres 274

Episode 274 July 16, 2023 00:14:40
Subquery Performance, Avoid Update Locking, Column Changes, Outage Workshop | Scaling Postgres 274
Scaling Postgres
Subquery Performance, Avoid Update Locking, Column Changes, Outage Workshop | Scaling Postgres 274

Jul 16 2023 | 00:14:40

/

Hosted By

Creston Jamison

Show Notes

 

In this episode of Scaling Postgres, we discuss subquery performance, how to avoid excessive locking when doing updates, how to change a columns datatype without excessive locking and lessons from an upgrade outage.

To get the show notes as well as get notified of new episodes, visit: 

https://www.scalingpostgres.com/episodes/274-subquery-performance-avoid-update-locking-column-changes-outage-workshop/

Other Episodes

Episode 70

July 01, 2019 00:12:57
Episode Cover

Default Security, Max Connections, Progress Reporting, Migration | Scaling Postgres 70

In this episode of Scaling Postgres, we discuss the default security, max_connections and pooling, progress reporting and migrating to Postgres. To get the show...

Listen

Episode 363

April 27, 2025 00:13:32
Episode Cover

Top Ten Postgres Dos & Don'ts | Scaling Postgres 363

In this episode of Scaling Postgres, we discuss a top ten dos and don't for Postgres, understanding statistics and extended statistics, aligning columns to...

Listen

Episode 385

September 28, 2025 00:17:07
Episode Cover

Postgres 18 Released! | Scaling Postgres 385

In this episode of Scaling Postgres, we discuss the release of Postgres 18 and cover different features such as asynchronous I/O, enhanced return from...

Listen