Looking Forward to Postgres 19: Query Hints
Postgres 19 brings plan advice: the query hints the Postgres community held off on for 15 years. Shaun Thomas covers the 15-year debate, pg_plan_advice, pg_stash_advice, and how to use them.
Build agentic AI and enterprise applications on 100% standard Postgres - then deploy on our cloud, your cloud, or your on-premises infrastructure, without ever changing platforms.
Visit pgedge.com → On Hacker News Sep 2025 – Jun 2026
Systems & Performance 2Databases & Data 2Open Source 1Tech Industry & Business 1
Postgres 19 brings plan advice: the query hints the Postgres community held off on for 15 years. Shaun Thomas covers the 15-year debate, pg_plan_advice, pg_stash_advice, and how to use them.
Postgres 19 brings native temporal table support. Shaun Thomas covers WITHOUT OVERLAPS, FOR PORTION OF, and temporal foreign keys - and what's still missing.
pgEdge is now fully open-source under the Postgres license. What that means for distributed PostgreSQL, the Spock extension, and our enterprise customers.