2006/4/6, Luckys <[EMAIL PROTECTED]>: > 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster