PostgreSQL Table Design

Acerca de

This skill provides comprehensive architectural guidance for building robust PostgreSQL databases, focusing on normalization, performance-tuned indexing, and modern features. It helps developers navigate common pitfalls—such as case-sensitivity issues and unindexed foreign keys—while enforcing strict standards for data integrity using constraints and Row-Level Security. Whether you are modeling complex relational data or optimizing for high-concurrency workloads, this resource ensures your schema leverages the full power of PostgreSQL features like JSONB, partitioning, and extension-specific types like pgvector.

Características Principales

• Guidelines for safe schema evolution and transactional DDL to prevent production downtime.
• 23,139 GitHub stars
• Advanced indexing patterns for B-tree, GIN, GiST, and BRIN to accelerate complex queries.
• Detailed implementation of constraints, partitioning, and Row-Level Security policies.
• Optimized data type selection including TIMESTAMPTZ, NUMERIC, and modern identity columns.
• Workload-specific tuning for update-heavy and insert-heavy data patterns.

Casos de Uso

• Architecting new relational database schemas for scalable applications.
• Optimizing existing database tables to reduce storage bloat and improve query performance.
• Implementing specialized storage solutions for time-series data, JSON documents, or vector embeddings.