Re: query optimizer - Mailing list pgsql-general

From Tom Lane
Subject Re: query optimizer
Date
Msg-id 5006.1184856063@sss.pgh.pa.us
Whole thread Raw
In response to Re: query optimizer  (Luca Ferrari <fluca1978@infinito.it>)
Responses Re: query optimizer
Re: query optimizer
Re: query optimizer
List pgsql-general
Luca Ferrari <fluca1978@infinito.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

pgsql-general by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: [PERFORM] Parrallel query execution for UNION ALL Queries
Next
From: Greg Smith
Date:
Subject: Re: query optimizer