postgres-patterns

Topics in the source

• PostgreSQL Patterns
• When to Activate
• Quick Reference
• Index Cheat Sheet
• Data Type Quick Reference
• Common Patterns
• Anti-Pattern Detection
• Configuration Template

Quick reference for PostgreSQL best practices. For detailed guidance, use the database-reviewer agent. Writing SQL queries or migrations Designing database schemas Troubleshooting slow queries Implementing Row Level Security Setting up connection pooling | Query Pattern | Index Type | Example | |--------------|------------|---------| | WHERE col = value | B-tree (default) | CREATE INDEX idx ON t (col) | | WHERE col > value | B-tree | CREATE INDEX idx ON t (col) | | WHERE a = x AND b > y | Composite | CREATE INDEX idx ON t (a, b) | | WHERE jsonb @> '{}' | GIN | CREATE INDEX idx ON t USING gin (col) | | WHERE tsv @@ query | GIN | CREATE INDEX idx ON t USING gin (col) | | Time-series ranges | BRIN | CREATE INDEX idx ON t USING brin (col) | | Use Case | Correct Type | Avoid | |----------|-------------|-------| | IDs | bigint | int, random UUID | | Strings | text | varchar(255) | | Timestamps | timestamptz | timestamp | | Money | numeric(10,2) | float | | Flags | boolean | varchar, int | Composite Index Order: Covering Index: Partial Index: RLS Policy (Optimized): UPSERT: Cursor Pagination: Queue Processing: Agent: database-reviewer - Full database review workflow Skill: clickhouse-io -

This is an excerpt. Refer to the complete source and its current requirements.