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/

Previous Episode
Next Episode

Other Episodes

Episode 295

December 17, 2023 • 00:15:32
Episode Cover

30K Messages Per Second Queue | Scaling Postgres 295

In this episode of Scaling Postgres, we discuss a 30K messages per second queue built on Postgres, a zero downtime logical replication upgrade, the...

Listen

Episode 224

July 18, 2022 • 00:13:57
Episode Cover

Column Performance, BRIN Win, Unique and Null, Parallel Distinct | Scaling Postgres 224

In this episode of Scaling Postgres, we discuss how too many columns in a table can affect performance, at what point BRIN indexes win...

Listen

Episode 319

June 09, 2024 • 00:12:05
Episode Cover

When Postgres Development Stopped! | Scaling Postgres 319

In this episode of Scaling Postgres, we discuss a time when Postgres development stopped, two new extensions pg_lakehouse & pg_compare and the upcoming event...

Listen