postgres-optimization

---
name: postgres-optimization
description: PostgreSQL optimization including indexes, query plans, partitioning, JSONB operations, and connection pooling
---

# PostgreSQL Optimization

## Index Strategies

```sql
-- B-tree index for equality and range queries (default)
CREATE INDEX idx_orders_customer_id ON orders (customer_id);

-- Composite index (column order matters: equality columns first, range last)
CREATE INDEX idx_orders_status_created ON orders (status, created_at DESC);

-- Partial