Tag: #query-planner
Writing on GPUs, LLMs, MLOps, Kubernetes — and mindset · 2 posts
pg_plan_advice in Postgres 19: The Compromise From a Project That Has Long Refused Hints
The PostgreSQL project has refused optimizer hints for a long time. But PostgreSQL 19 Beta 1, released on June 4, 2026, added two contrib modules built by Robert Haas: pgplanadvice and pgstashadvice. This isn't Oracle-st
2026-07-16 · 14 min read #postgresql#query-planner#query-optimization#database#performanceDatabase Complete Guide — Internals, Indexes, Query Planner, Partitioning, Vector DB (Season 2 Ep 13, 2025)
Treat a database as nothing but "the place where SQL goes" and you stay junior forever. The internals of B-Tree, LSM-Tree, and Hash Index; how the query planner turns a query into an execution plan; the four transaction
2026-04-15 · 14 min read #database#postgresql#b-tree#lsm-tree#indexing