Need help detecting & fixing slow Postgres queries? Watch our webinar to learn how Query Advisor, a first-of-its-kind query optimization workflow purpose-built for Postgres coming soon to pganalyze, can help speed up queries (by over 1000x in one case) by selecting a better plan.| pganalyze
We discuss a commonly encountered Postgres planner quirk, which is how Postgres behaves when you have a LIMIT and an ORDER BY clause, and it picks the wrong index.| pganalyze
We introduce the new pg_query release that supports turning SQL queries with Postgres 16 syntax into parse trees.| pganalyze