Primary production database — JSONB, full-text search, CTEs, window functions, and pgvector for AI.
PostgreSQL is my default for every project. ACID compliance, JSONB, powerful query planner, full-text search, CTEs, window functions, pgvector extension. I optimize with EXPLAIN ANALYZE, strategic indexes, partitioning, PgBouncer pooling.