소개
This skill provides comprehensive, domain-specific guidance for designing high-performance PostgreSQL databases. It covers essential core rules like normalization to 3NF, specific data type recommendations (such as preferring TIMESTAMPTZ and BIGINT), and advanced indexing strategies including GIN and GiST. By incorporating PostgreSQL-specific 'gotchas'—like the lack of automatic foreign key indexing and the nuances of MVCC—this skill ensures that your database structures are not just syntactically correct, but optimized for the unique architecture of PostgreSQL. It is particularly useful for developers building complex applications that require robust constraints, efficient partitioning for large datasets, and safe schema evolution.
