State Of Postgres 2023 | Scaling Postgres 296

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

In this episode of Scaling Postgres, we discuss the State of Postgres 2023 survey, a repository of Postgres how-tos, ways foreign keys can break and a custom SQL playground.

Want to learn more about Postgres performance?

Timestamps:
00:00 - Intro
00:39 - State of Postgres 2023
02:46 - postgres-howtos
03:56 - Broken foreign keys: how can that happen in PostgreSQL?
06:40 - The Postgres Playground: BYOS (Bring Your Own SQL)
07:55 - Zero downtime Postgres upgrades and how to logically replicate very large tables
08:37 - Starting PostgreSQL logical replication for some tables based on a dump
10:11 - Hash indexes
11:52 - What you should know about PostgreSQL minor upgrades
14:05 - Global search inside a database
15:14 - Highlights from podcast episode about Postgres monitoring with Lukas Fittl and Rob Treat
15:33 - Extracting SQL from WAL? (part 2)
15:59 - Data Science is Getting Ducky
16:46 - Working with GPS data in PostGIS
16:56 - PostGIS Clustering with DBSCAN
17:11 - Outro

#postgres #postgresql

[NikolaySamokhvalov]

as usual, thanks for including – and happy new year!