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 248

January 15, 2023 • 00:17:20

Pagination Solutions, Return Modifications, Insert Deletions, How To JSON | Scaling Postgres 248

In this episode of Scaling Postgres, we discuss different pagination solutions, how to return modifications, soft deletion alternatives and how to use JSON with...

Episode 210

April 10, 2022 • 00:09:52

Date Time Bins, Search Every Field, JSON_TABLE, Picking Primary | Scaling Postgres 210

In this episode of Scaling Postgres, we discuss how to bin date times, search every field of a table, use JSON_TABLE and methods for...

Episode 167

May 30, 2021 • 00:18:42

Interpreting Explain Analyze, Bulk Loading Data, Limiting Update & Delete, pg_buffercache | Scaling Postgres 167

In this episode of Scaling Postgres, we discuss how to interpret explain analyze, the best ways to load data in bulk, how to limit...