postgres-patterns

PostgreSQL index selection depends on matching index types like B-tree, GIN, BRIN, composite, or partial indexes to specific query filters. This skill provides optimized index recommendations by analyzing query patterns and schema designs to resolve slow database performance.

Designing row level security policies for multi-tenant PostgreSQL databases requires applying tenant isolation rules to tables. This skill supplies ready-to-use row level security policy templates and configuration settings for secure multi-tenant database setups.

Use BRIN or GIN indexes instead of B-tree when handling large datasets with natural ordering or full-text search requirements. This skill offers guidance and cheat sheets for applying BRIN, GIN, composite, and covering indexes to specific PostgreSQL use cases.

Finding unindexed foreign keys and table bloat in PostgreSQL requires running specific diagnostic SQL queries against the database. This skill supplies anti-pattern detection queries to identify unindexed foreign keys, slow queries, and table bloat affecting database performance.

This PostgreSQL optimization skill does not require external tooling to generate indexing and schema recommendations. It satisfies requirements for B-tree, GIN, BRIN, partial indexes, and row-level security policies directly without external dependencies.

Partial indexes limit query optimization to queries that match the index's specific conditional predicate. This skill provides best-practice patterns for applying partial, covering, and composite indexes correctly to avoid mismatched query filters and suboptimal performance.