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 298

January 14, 2024 • 00:19:28
Episode Cover

10-100 Times Higher Latency With Distributed Postgres | Scaling Postgres 298

In this episode of Scaling Postgres, we discuss hopes for Postgres in 2024, whether you need foreign keys, incremental backups, and five ways of...

Listen

Episode 378

August 10, 2025 • 00:19:29
Episode Cover

Native Column Store? | Scaling Postgres 378

In this episode of Scaling Postgres, we discuss Postgres getting a native column store via an index, faster btree_gift indexes, scaling listen/notify, and a...

Listen

Episode 178

August 16, 2021 • 00:15:11
Episode Cover

Postgres Releases, Performance Discussion, Index Types, Index Power Use | Scaling Postgres 178

In this episode of Scaling Postgres, we discuss new releases for Postgres & pgbouncer, have a performance discussion, describe the different index types and...

Listen