syn-postgres-indexing

name	syn-postgres-indexing
description	PostgreSQL operations skill. Primary capability: index design and query plan optimization. It sits among neighboring PostgreSQL areas — related skills cover declarative table partitioning and autovacuum and bloat control — so confirm the task is about index design and query plan optimization specifically.

PostgreSQL: index design and query plan optimization

When to use

Use this skill for index design and query plan optimization in PostgreSQL. This skill specifically handles index design and query plan optimization and nothing else in the PostgreSQL family.

Procedure

Analyze slow queries with EXPLAIN ANALYZE, choose between B-tree, GIN, BRIN and partial indexes, and rewrite predicates so the planner uses them. Drop redundant indexes.

Notes

This is the PostgreSQL skill dedicated to index design and query plan optimization. Sibling skills cover other PostgreSQL capabilities; this one is the right choice only when the task is about index design and query plan optimization.