PostgreSQL for Data Engineering

When to Use

Load this skill when the task involves:

• Designing or maintaining large PostgreSQL tables with declarative partitioning
• Choosing or creating indexes (B-Tree, BRIN, GIN, GIST, partial, covering)
• Bulk-loading data with COPY, unlogged tables, or pg_bulkload
• Diagnosing slow queries with EXPLAIN / EXPLAIN ANALYZE
• Tuning autovacuum to prevent table bloat
• Writing advanced SQL: window functions, JSONB, CTEs, LATERAL joins
• Any DE pipeline that reads/writes PostgreSQL as a source or sink

1. Declarative Partitioning

Strategy Selection