Re: query optimizer

On Thu, Jul 19, 2007 at 10:41:03AM -0400, Tom Lane wrote:
> 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 :-(

How long ago was this (that they were on the website)? I don't recall that
ever being removed, and I can't find it in the cvs either.

If you still have the presentations, we can always add them back in... (I
recall reading them, but don't have a local copy)

//Magnus