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