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 203

February 20, 2022 • 00:12:11

Saving Space, Working with TOAST, Protecting Data, High CPU Utilization | Scaling Postgres 203

In this episode of Scaling Postgres, we discuss the new releases of Postgres, a hairy upgrade incident, why slowing down can make you go...

Episode 192

November 23, 2021 • 00:12:39

Foreign Key Indexes, Graph Queries, Linux Huge Pages, Text Column Size | Scaling Postgres 192

In this episode of Scaling Postgres, we discuss if foreign keys should have indexes, how to run graph queries, how to configure Linux huge...

Episode 29

September 10, 2018 • 00:13:27

Parallel Indexing, SQL vs. ORM, Logical Replication Upgrades | Scaling Postgres 29

In this episode of Scaling Postgres, we review articles covering parallel indexing, SQL vs. ORM, logical replication upgrades and development DBs. To get the...