postgresql

@kumaran-is

PostgreSQL-specific schema design reference for advanced data types (ENUM, array, range, network, domain), storage internals (MVCC, HOT updates, TOAST, heap), and advanced constraints (EXCLUDE, generated columns). Use when designing PostgreSQL schemas, choosing data types, working with extensions (pgvector, PostGIS, TimescaleDB), or handling schema evolution safely without downtime.