Subquery Performance, Avoid Update Locking, Column Changes, Outage Workshop

Scaling Postgres

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

Jul 16 2023 | 00:14:40

00:00 / 00:14:40

Hosted By

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 230

August 28, 2022 • 00:12:33

Stats Collector Gone, Handling Latency, PG In The Browser, Future High Availability | Scaling Postgres 230

In this episode of Scaling Postgres, we discuss how the stats collector disappears in PG15, steps to mitigate high latency connections, how to run...

Episode 10

April 30, 2018 • 00:12:12

ANSI Schmansi, Split-Brain, Performance Scenarios, Parallelism | Scaling Postgres 10

In this episode of Scaling Postgres, we review articles covering ANSI Schmansi, split-brain replication issues, performance solutions to business scenarios and paralellism. To get...

Episode 1

February 27, 2018 • 00:17:44

Petabyte Scale and Locking | Scaling Postgres 1

In this episode of Scaling Postgres, we review articles covering petabyte scale techniques as well as various articles on locking. To get the show...