Postgres optimizer

Started by Sureshalmost 19 years ago2 messages
#1Suresh
suiyengar@yahoo.com

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 ?

Also, how to I start changing Postgres Code using eclipse platform (with tracing, debug functionalities ) ?

Thanks,
Suresh

---------------------------------
Need Mail bonding?
Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users.

#2Mark Kirkwood
markir@paradise.net.nz
In reply to: Suresh (#1)
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