Обсуждение: Postgres optimizer

Поиск
Список
Период
Сортировка

Postgres optimizer

От
Suresh
Дата:
<span id="intelliTxt">Hi,<br /><br /> I want to get the coding details regarding postgres optimizer. Essentially, which
filescorrespond to which functions, how the algo is implemented, the flow etc.. Where can I find this material ?<br
/><br/> Also, how to I start changing Postgres Code using eclipse platform (with tracing, debug functionalities ) ?<br
/><br/>Thanks,<br />Suresh<br /></span><p><hr size="1" />Need Mail bonding?<br />Go to the <a
href="http://answers.yahoo.com/dir/index;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=ask&sid=396546091">Yahoo!
MailQ&A</a> for <a
href="http://answers.yahoo.com/dir/index;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=ask&sid=396546091">great
tipsfrom Yahoo! Answers</a> users.

Re: Postgres optimizer

От
Mark Kirkwood
Дата:
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