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&gt;

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

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

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

Nicolas

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

On Thursday 06 April 2006 07:43, Nicolas Barbier wrote:

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&gt;

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

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

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

I feel somewhat obligated to add the following to the list:
http://techdocs.postgresql.org/oscon2005/robert.treat/ contains the open
office presenation file. If you google on "explaining explain" you can get
an html version.

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL