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