Scaling Postgres Episode 169 Bigint | High Availability | Autocommit | Synchronized Sequential Scans

To get the show notes as well as get notified of new episodes, visit:

In this episode of Scaling Postgres, we discuss only using bigint, high availability, Postgres autocommit and synchronized sequential scans.

Want to learn more about Postgres performance?

Timestamps:
00:00 - Intro
00:28 - Use BIGINT in Postgres
02:58 - PostgreSQL HA with Patroni: Your Turn to Test Failure Scenarios
04:31 - Disabling autocommit in PostgreSQL can damage your health
07:38 - Data warehousing: Making use of synchronized seq scans
09:51 - Better Range Types in Postgres 14: Turning 100 Lines of SQL Into 3
11:17 - [YouTube] PostgreSQL Fetching large amounts of data - EXPLAINING PostgreSQL
12:13 - PostgreSQL as a Microservice
13:13 - Ignore nulls in Postgres
15:04 - Postgres 14 highlight - Memory dumps
16:04 - PostgreSQL on Linux: Counting Committed Memory
16:30 - Grafana dashboards for pgSCV.
17:23 - Time Zone Abbreviations
17:49 - Percona YouTube Channel
18:10 - Tom Kincaid
18:21 - Outro

#postgres #postgresql

[mikejakubik]

Finally a good PostgreSQL vlog by someone that actually speaks English!