Hacking On Postgres is Hard! | Scaling Postgres 315

To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/315-hacking-on-postgres-is-hard/ 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: https://www.scalingpostgres.com/courses/postgresql-performance-starter-kit/ 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