Design PostgreSQL schemas and indexes
postgresqlskillsetup L2★0
Sheshiyer/skill-clusters ↗What it does
Design PostgreSQL schemas with normalization, indexing, and data types
Best for
When you need to model a relational schema with correct constraints, performance tuples, and MVCC semantics.
Inputs
- · domain requirements
- · query patterns
- · data volume estimates
Outputs
- · DDL schema
- · index recommendations
- · normalization advice
Preconditions
- · Domain model defined
- · Access patterns known
Failure modes
- · Over-normalization killing reads
- · Missing FK indexes
- · wrong data types for precision/range
Trust signals
- · 3NF design
- · tested on production volume
- · index cardinality verified