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/

Other Episodes

Episode 50

February 11, 2019 00:14:23
Episode Cover

Outage from TXIDs, Breaking Scale, fsync Gate, pg_stat_statements | Scaling Postgres 50

In this episode of Scaling Postgres, we review articles covering an outage from running out of TXIDs, breaking scale, that PG fsync issue and...

Listen

Episode 184

September 26, 2021 00:12:37
Episode Cover

Postgres 14 RC1, Little Things, Index Advisor, Million Inserts | Scaling Postgres 184

In this episode of Scaling Postgres, we discuss Postgres 14 RC1, little improvements in PG14, an index advisor and how to handle 1 million...

Listen

Episode 74

July 29, 2019 00:11:11
Episode Cover

Picturing Vacuum, Recovery Changes, Cert Authentication, Function Replication | Scaling Postgres 74

In this episode of Scaling Postgres, we discuss vacuum through pictures, upcoming recovery changes, certification authentication and how functions get replicated. To get the...

Listen