The Art of SQL Query Optimization

314 · Jan Nidzwetzki · June 3, 2025, 9:39 p.m.
postgresql Query Optimization Research software development postgresql Query Optimization SQL
Summary
This blog post discusses SQL query optimization, highlighting the role of the query optimizer in database management systems and the author's experience developing a plan explorer tool for PostgreSQL. The tool visualizes plan changes and provides insights into optimizer decisions, enhancing the understanding and efficiency of SQL queries.
Read full post on jnidzwetzki.github.io →
AUTHOR
BLOG POST FEATURED ON

Placeholder image
r/programming

23 points

Placeholder image
Hacker News

14 points

Add this plugin to your blog