Scaling Postgres Episode 132 Postgres 13 RC1 | Upgrading at Scale | With Ties | HOT Updates

preview_player
Показать описание
To get the show notes as well as get notified of new episodes, visit:

In this episode of Scaling Postgres, we discuss the release of Postgres 13 RC1, how to upgrade Postgres at scale, using limit with ties and understanding Heap Only Tuple (HOT) updates.

Want to learn more about Postgres performance?

Timestamps:
00:00 - Intro
00:28 - PostgreSQL 13 RC 1 Released!
05:35 - PostgreSQL 13: LIMIT … WITH TIES
06:56 - HOT updates in PostgreSQL for better performance
12:13 - 7 Best Practice Tips for PostgreSQL Bulk Data Loading
13:59 - Hidden Gems of PostgreSQL 13
15:28 - Postgres and the Artificial Intelligence Landscape
16:13 - Exploring PL/Python: Turn Postgres Table Data Into a NumPy Array
16:42 - Talking about Citus & Postgres at any scale
17:01 - Anthony Nowocien
17:14 - Outro

#postgres #postgresql
Рекомендации по теме
Комментарии
Автор

Hi Creston! OnGres Engineer here, part of the team that directed the upgrade. The PgBouncer iLB is just a GCP iLB Endpoint, for the R/W layer. The local PgBouncers serve the RO Workhorse API, within its traffic balanced through DNS round robin. Great content!

emanuelcalvo
Автор

Thanks a lot for keep on sharing the valuable information.

bingxie