Seven Years of Scaling Postgres | Scaling Postgres 350

To get the show notes as well as get notified of new episodes, visit:
www.scalingpos...
In this episode of Scaling Postgres, we discuss our seven year anniversary, better pg_search performance, reducing table locks, not valid constraints and better group by statistics.
Want to learn more about Postgres performance?
Join my FREE training called Postgres Performance Demystified here: www.scalingpos...
Timestamps:
01:42 - A New Postgres Block Storage Layout for Full Text Search
04:34 - Anatomy of table-level locks: Reducing locking impact
08:25 - NOT VALID constraints
10:37 - GROUP BY: Fixing optimizer estimates
12:28 - January Meetup: “Who needs Kafka?”
13:01 - PostgreSQL 18: Add OLD/NEW support to RETURNING in DML queries
13:59 - Waiting for PostgreSQL 18 - Enable BUFFERS with EXPLAIN ANALYZE by default
14:38 - How to Test Your PostgreSQL Connection
15:19 - Logical replication in Postgres: Basics
15:33 - Who Contributed to PostgreSQL Development in 2024?
16:26 - PostgreSQL Hacking Workshop - February 2025
16:51 - Consulting Corner
18:50 - Outro
#postgres #postgresql

[@sanjaysampath80]

Congrats on 7 years! Wishing you many more years of posting videos.

[@avery7292]

Congratulations on 7 years of scaling postgres!

[@ScalingPostgres]

Thanks!

[@richarddemke1290]

Congrats! Haven’t been here for all 7 years but will be for the next 7!

[@ScalingPostgres]

Thanks!

[@berndeckenfels]

Great for such a Long consistent service, thanks a lot

[@ScalingPostgres]

Your welcome!

[@jaimeduncan6167]

Congratulations and thanks for the effort.

[@ScalingPostgres]

Thanks!

[@Vicky_Lines]

Congrats for the 7th year giving us infos and motivating to use postgres. :)

[@ScalingPostgres]

You bet!

[@miguelfrosales01]

Congrats! I love your content!

[@ScalingPostgres]

Glad you enjoy it!

[@RU-qv3jl]

Congrats on the 7 years. Nice change with the consultancy corner as well 👍

[@ScalingPostgres]

Thanks! I am glad you like the addition.

[@smyrnian_]

Congratulations! But not enough content on actually "Scaling" Postgres.

[@ScalingPostgres]

Well, a bit at the mercy of what content gets created weekly. Sometimes there is a lot, sometimes there is a little.

[@PostgresTV]

Congrats with 7y - and thanks for mentioning .FM and BUFFERS (oh yes)!

[@ScalingPostgres]

Thanks!