Tag: #index
Writing on GPUs, LLMs, MLOps, Kubernetes — and mindset · 2 posts
The Complete Guide to PostgreSQL Indexes: The Index Lifecycle from Design to Retirement
This piece treats the PostgreSQL 18 index as an operational asset with a full lifecycle: the design decisions behind column order, the judgment call between six index types, the procedure for building one safely with CON
2026-08-15 · 23 min read #database#postgresql#index#performance-tuning#operationsWhy the Index You Created Is Not Being Used — The Cases Where the Optimizer Is Right and You Are Wrong
A cause-by-cause breakdown of why a Seq Scan stays in the query plan even after you create an index. Low selectivity making the optimizer ignore it on purpose, a function or arithmetic on the column making the condition
2026-07-26 · 14 min read #database#postgresql#index#query-optimization#mysql