postgres-patterns

Review Alembic migrations using safe naming and named constraints to minimize PostgreSQL downtime. These migration-review patterns provide concrete upgrade strategies that ensure scalable database deployments across typical application workloads.

Design partial and JSONB indexes by aligning index structures to common query shapes. This approach provides concrete, ready-to-apply SQL patterns that improve read throughput and ensure efficient filtering for typical PostgreSQL workloads.

Analyze PostgreSQL query plans using EXPLAIN ANALYZE guidance to identify bottlenecks. The skill provides concrete query performance templates and tuning steps to reduce runtime and improve read throughput for slow queries.

Yes, you can apply these SQL patterns to optimize existing PostgreSQL workloads. The patterns provide index design and query optimization steps that reduce runtime and improve read throughput for typical application database operations.

Use partial indexes instead of standard indexes when optimizing frequently filtered PostgreSQL queries. These index design patterns target specific query shapes, reducing storage overhead and improving read throughput for typical application workloads.