Postgres extensions

Postgres extensions add new types, functions, operators, and index methods without touching the core. CREATE EXTENSION name; and suddenly Postgres has a new capability. The ones that show up constantly: PostGIS — geographic data, nearest-neighbour queries, geofencing — turns Postgres into a serious GIS database; pg_stat_statements — tracks query performance across the fleet, the single most useful extension for figuring out what's actually slow; uuid-ossp / pgcrypto — UUID generation and crypto primitives; pgvector — vector similarity search for AI embeddings, making Postgres a credible alternative to Pinecone/Qdrant for many workloads; TimescaleDB — repackages Postgres as a time-series DB. The broader pattern: the extension ecosystem is why "just use Postgres" is increasingly the right default even when the workload sounds niche — someone has probably already built a Postgres extension for it.