PostgreSQL 19 is adding query plan hints, called “advice.”
Before overriding the planner:
• Run ANALYZE
• Check indexes and fix statistics.
If you still need advice, scope it by query ID and keep checking EXPLAIN.
See how pg_plan_advice works:
Introducing PostgreSQL for agents in AlloyDB!
Agent queries can overwhelm standard databases. Now you can:
- Keep core business systems protected
- Get fast access to live operational data
- Scale to 1,000+ readers on demand
Read how it works 👉
Introducing PostgreSQL Hub. Explore resources, guidance, and tools to help organizations build, optimize, and scale PostgreSQL workloads on Azure.
Learn more:
Scale PostgreSQL reads the easy way. In #AzureFriday#, @shanselman and Paula Berenguel show how PostgreSQL on Azure uses read replicas and virtual endpoints to handle heavy read workloads, just like OpenAI powers ChatGPT on Postgres.
Watch now:
Managing PostgreSQL at scale? Discover how Azure and VS Code help teams identify issues faster, improve reliability, and optimize performance with confidence. Read the blog.
Connects to PostgreSQL, MySQL, SQLite, Redis, MongoDB, SQL Server, and ClickHouse through a single native desktop application with a built-in MCP server.
Unifies access to PostgreSQL, MySQL, SQLite, and 15+ additional databases through a single desktop application featuring an internal MCP server for AI agent connectivity.
What’s new with PostgreSQL at Microsoft in 2026? From developer tools, open-source contributions, Azure HorizonDB, Azure Database for PostgreSQL, and community initiatives, catch up on the latest innovations shaping the future of Postgres. Read the blog.
AI is driving new PostgreSQL adoption. See how organizations are moving to Azure to modernize faster, simplify operations, and build AI ready apps. Learn what customers are unlocking: