Subquery Performance, Avoid Update Locking, Column Changes, Outage Workshop | Scaling Postgres 274
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episo...
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.
Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: https://www.scalingpostgres.com/cours...
Timestamps:
00:00 - Intro
00:30 - Subqueries and Performance in PostgreSQL
03:23 - Using correlated subqueries to force nested loop joins
03:24 - Prevent Locking Issues For Updates On Counters
05:32 - Online Data Type Change in PostgreSQL
07:22 - Let's Workshop an Unplanned Postgres Outage
09:35 - PGSQL Phriday #010: Log Analysis
09:59 - # pgbadger PGSQLPhriday - Anthony Nowocien
10:14 - pgvector 0.4.0 performance
10:32 - Qdrant vs pgvector - Results from the 1M Open AI Benchmark
11:09 - Compressing (Not So) Immutable Data: How We're Changing Time-Series Data Management
12:19 - Understanding RDS Cost
12:32 - PostgreSQL 14 Internals for print on demand
12:50 - Ccache and PostgreSQL build directories
13:01 - Announcing Crunchy Postgres for Kubernetes 5.4
13:21 - POSTGIS. ARCGIS Enterprise and The Tour De France Route
13:35 - MapScaping Podcast: Pg_EventServ
13:53 - Anniversary mailbag
14:14 - Outro
#postgres #postgresql
On this page of the site you can watch the video online Subquery Performance, Avoid Update Locking, Column Changes, Outage Workshop | Scaling Postgres 274 with a duration of hours minute second in good quality, which was uploaded by the user Scaling Postgres 16 July 2023, share the link with friends and acquaintances, this video has already been watched 603 times on youtube and it was liked by 35 viewers. Enjoy your viewing!
