Unconventional Advice? | Scaling Postgres 379

Описание: 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 when you should reindex, how to handle case insensitive data, how to index jsonb and the top recommendations when doing performance optimizations.

Want to learn more about Postgres performance?
Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/cours...

Timestamps:

00:34 - Should I rebuild my PostgreSQL index?
04:40 - caSe-inSENsiTive
07:59 - Indexing JSONB in Postgres
09:44 - Bypass PostgreSQL catalog overhead with direct partition hash calculations
12:34 - PG Lord of the Ring
14:05 - pg_stat_monitor Needs You! Join the Feedback Phase
14:25 - Lies, Damn Lies, and LLM Output.
15:24 - AI for data engineers with Simon Willison
15:47 - CloudNativePG 1.27.0 Released!
16:06 - Consulting Corner
18:43 - Outro

#postgres #postgresql