EPISODE · Jul 16, 2023 · 14 MIN
Subquery Performance, Avoid Update Locking, Column Changes, Outage Workshop | Scaling Postgres 274
from Scaling Postgres · host Creston Jamison
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/
What this episode covers
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/
NOW PLAYING
Subquery Performance, Avoid Update Locking, Column Changes, Outage Workshop | Scaling Postgres 274
No transcript for this episode yet
Similar Episodes
Jul 20, 2026 ·13m
Jul 19, 2026 ·43m
Jul 15, 2026 ·15m
Jul 13, 2026 ·11m