The Rise of PostgreSQL as the Everything Database | POSETTE: An Event for Postgres 2026

Varun Dhawan explains why PostgreSQL is increasingly used as an “everything database” and how its extensibility lets teams consolidate workloads like OLTP, analytics, and vector search. He also connects these capabilities to Azure Database for PostgreSQL and scaling patterns such as Citus.

Overview

Why PostgreSQL is trending toward an “everything database”

The talk frames PostgreSQL as moving beyond a traditional transactional (OLTP) database into a platform that can cover multiple data workloads, reducing the need for separate specialized systems and the operational complexity of running them.

Capabilities highlighted in PostgreSQL

• Document-style data with JSON: using native JSON support to cover use cases that might otherwise push teams toward a separate document database.
• Caching-style patterns: using PostgreSQL in roles that can reduce the need for a separate cache layer in some architectures.
• Time-series and GIS: supporting time-series workloads and geospatial (GIS) scenarios.
• Full-text search: built-in text search capabilities.
• Vector embeddings / vector search: storing and querying vector embeddings for AI-related retrieval scenarios.
• Graph queries and analytics (OLAP): covering additional query patterns and analytical workloads.

Scaling patterns and Azure context

• Scaling beyond a single node: the session calls out scaling approaches including Citus and Azure-native capabilities.
• Azure Database for PostgreSQL: positioned as a managed option to run PostgreSQL in Azure with reliability and managed infrastructure, while staying aligned with PostgreSQL’s open-source ecosystem.

Links

• POSETTE conference site: https://posetteconf.com
• POSETTE playlist: https://aka.ms/posette-playlist
• Stack Overflow Developer Survey 2025 (databases): https://survey.stackoverflow.co/2025/technology#1-databases