Postgres 16 Released, Postgres Meme, File vs base64 Strings, Citus Sharding | Scaling Postgres 282

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 16, a Postgres meme, storing files or base64 strings and sharding intelligently.

Want to learn more about Postgres performance?

Timestamps:
00:00 - Intro
00:29 - PostgreSQL 16 Released!
03:00 - PGSQL Phriday #12 Contribution Summary
03:19 - Bidirectional Logical Replication in PostgreSQL 16
03:46 - PostgreSQL 16 has better number literals
04:00 - Our favourite v16 feature
04:25 - Explaining The Postgres Meme
06:11 - We used to store files as base64 strings in Postgres, but not anymore
07:56 - Data Locality: Scaling PostgreSQL with CITUS Intelligently
09:56 - CITUS: Sharding your First Table
10:32 - Monitoreing PostgreSQL Replication
12:24 - Who's in charge? Postgres project organization
13:03 - Episode 7 highlights of Path to Citus con podcast w/ Paul Ramsey & Regina Obe
13:23 - Random Geometry Generation with PostGIS
13:35 - Outro

#postgres #postgresql

[umardev]

citus is trash because if one of nodes is off that query is failed