PostgreSQL Table Design

Comprehensive PostgreSQL schema design guide with excellent coverage of types, indexes, and gotchas

• +Covers extensive PostgreSQL-specific features with concrete examples and rationale
• +Highlights critical gotchas like FK indexing and MVCC behavior agents often miss
• +Provides clear anti-patterns and type selection guidance with performance context
• -Content appears truncated mid-sentence in multiple sections
• -Requests filesystem write permission without clear justification in the workflow