Re: Explaining Explain

2006/4/6, Luckys <plpgsql@gmail.com>:

> I'm looking for some comphrensive article explaining the Optimizer, i.e
> detailed explanation on Hash joins, Nested Joins etc., and why would the
> Optimizer choose that.
> can anybody point me to some good tutorials and resources?

"A Tour of PostgreSQL Internals":
<url:http://www.postgresql.org/files/developer/tour.pdf>

"Recent PostgreSQL Optimizer Improvements":
<url:http://conferences.oreillynet.com/cs/os2003/view/e_sess/4372>

"Inside the PostgreSQL Query Optimizer":
<url:http://lca2005.linux.org.au/Papers/Neil%20Conway/Inside%20the%20PostgreSQL%20Query%20Optimizer/index.html>

The manual: <url:http://www.postgresql.org/docs/current/static/planner-optimizer.html>

Nicolas

--
Nicolas Barbier
http://www.gnu.org/philosophy/no-word-attachments.html