222 Times Faster Analytical Queries With Columnar Storage | Scaling Postgres 283

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 how to get 222 times faster analytical queries with columnar storage, a Postgres 16 feature review, the birth of a feature and fuzzy search.

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:23 - Hydra: Hydra 1.0 Generally Available
04:12 - Cybertec: Citus: Row Store Vs. Column Store in PostgreSQL
05:51 - Fujitsu PostgreSQL blog: Discussing PostgreSQL: What changes in version 16, how we got here, and what to expect in future releases
07:48 - crunchydata: Active Active in Postgres 16
09:13 - crunchydata: JSON Updates in Postgres 16
09:44 - pganalyze: Postgres 16 is released!
10:07 - Eisentraut: Gouping digits in SQL
11:29 - Cybertec: "HIRED" vs. "FIRED" - Fuzzy Search in PostgreSQL
12:45 - postgres.fm: Logical Replication
13:19 - tembo: Enter the matrix: the four types of Postgres extensions
14:24 - Cybertec: CITUS: 7 Commonly used advanced SQL Tools
15:40 - Outro

#postgres #postgresql