Re: query optimizer

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Luca Ferrari <fluca1978(at)infinito(dot)it> writes:
> I'd like to better understand how the optimizer works and is implemented. Is 
> there any available documentation (before start reading the source!) to 
> understand concepts about geqo and system r? Any chance about any demo or 
> presentation with detailed examples (about how the optimizer makes and 
> discards choices, not about how to read the planner output)?

http://developer.postgresql.org/pgdocs/postgres/overview.html
(particularly 42.5)

src/backend/optimizer/README

The developers section of the website used to have slides from a couple
of talks I gave at OSCON, but I don't see them there anymore :-(

			regards, tom lane