Re: Postgres optimizer

Suresh wrote:
> Hi,
> 
> I want to get the coding details regarding postgres optimizer. 
> Essentially, which files correspond to which functions, how the algo is 
> implemented, the flow etc.. Where can I find this material ?
> 
> 

Maybe start with the docs, there a good section on optimization:
http://www.postgresql.org/docs/8.2/static/overview.html

And the README for the optimizer module in the code is worth a look too:
http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/README?rev=1.39

Cheers

Mark