| From: | "Nicolas Barbier" <nicolas(dot)barbier(at)gmail(dot)com> |
|---|---|
| To: | Luckys <plpgsql(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Explaining Explain |
| Date: | 2006-04-06 11:43:19 |
| Message-ID: | b0f3f5a10604060443qb100164s1f9bf6a4567820c9@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
2006/4/6, Luckys <plpgsql(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonah H. Harris | 2006-04-06 12:51:57 | Re: Support Parallel Query Execution in Executor |
| Previous Message | Jim Nasby | 2006-04-06 11:41:55 | Windows installer bugs (was: [BUGS] BUG #2374: Installation Error) |