Ottertune Is Dead! | Scaling Postgres 321
Join Over 1,000 Engineers & Get New Episodes Weekly!
In this episode of Scaling Postgres, we discuss the shutdown of Ottertune, how schema changes cause locks and how to avoid them, the benefits of on conflic do nothing, and pgvectorscale.
Content Discussed
- Ottertune is dead!
- Schema changes and the Postgres lock queue
- Reduce Vacuum by Using “ON CONFLICT” Directive
- pgvectorscale
- PostgreSQL Development Conference 2024 - Review
- Extension Ecosystem Summit 2024
- POSETTE 2024 [Review]
- [YouTube] Posette 2024 Talks
- POSETTE 2024 — How to Work with Other People
- The time keepers: pg_cron and pg_timetable
- The surprising logic of the Postgres work_mem setting, and how to tune it
- Postgres at the Kubernetes Podcast
- From Microsoft SQL server to PostGIS
- How to Use Composite Indexes in SQL to Speed Up Queries
- Compiling Postgres with LLVM
- Compiling latest gcc to test more architectures
- William Ivanski
- The limitations of LLMs, or why are we doing RAG?
- Postgres Ibiza 2024: September 9th-11th
- Portability via Static Linking of libpq
- Kubernetes Operator Meets Fully Managed Postgres