Hacking On Postgres is Hard! | Scaling Postgres 315
To get the show notes as well as get notified of new episodes, visit:
www.scalingpostgres.com/episo...
In this episode of Scaling Postgres, we discuss how hacking on Postgres is hard, a notifier pattern for using Listen/Notify, using histograms for metrics and saturated arithmetic.
Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: www.scalingpostgres.com/cours...
Timestamps:
00:00 - Intro
00:25 - Hacking on PostgreSQL is Really Hard
05:23 - The Notifier Pattern for Applications That Use Postgres
08:06 - Histograms worked
09:21 - Saturation Arithmetic with a PostgreSQL Extension
10:29 - Postgres Planner Quirks: The impact of ORDER BY + LIMIT on index usage
12:32 - LIMIT vs Performance
13:23 - What's new in pgvector v0.7.0
14:39 - (Bi) Temporal Tables, PostgreSQL and SQL Standard
16:58 - How not to change PostgreSQL column type
18:02 - CURSOR_TUPLE_FRACTION AND THE POSTGRESSQL JDBC DRIVER
19:05 - Outro
#postgres #postgresql
Пікірлер: 10
this reminds me of the often overlooked technical debt of unmaintained or non existing design or architecture documentation.
Thank you!
@ScalingPostgres
Ай бұрын
Welcome!
Thanks for the great content as always. I'm listening in the morning with my coffee
@ScalingPostgres
Ай бұрын
You're welcome!
Your episode content page has more entries than discussed in this video
@ScalingPostgres
Ай бұрын
Yep, I limit the show to what I think are the top 10. Otherwise, the show would be way too long. I include all the content I found in the past week on the web page in case someone wants to see the content that did not make the cut.
Thanks for these!
@ScalingPostgres
Ай бұрын
My pleasure!