Postgres Pro
Downloads
Home   >   mailing lists

Thread: looking for documentation about the optimizer

looking for documentation about the optimizer

From
"Alice Lottini"
Date:
Hi,
I'm a student in Informatics Engineering and I'm working at my thesis, for which I have to integrate one or more primitives in PostgreSQL in order to support data mining algorithms; this task firstly requires a deep analysis on the PostgreSQL optimizer (the way it works and its source code).
Does anybody know where I can find some documentation about the PostgreSQL optimizer?
I've read some old messages (1997) about an "Implementation Guide" but the related link seems to be obsolete ("page not found")...
Any suggestion is welcome!
thanks in advance, alice

Re: looking for documentation about the optimizer

From
Tom Lane
Date:
"Alice Lottini" <alice_lottini@yahoo.it> writes:
> Does anybody know where I can find some documentation about the PostgreSQL =
> optimizer?

Aside from the general info in the Developer's Guide, there are README
files in the source tree that you should look at:
    src/backend/optimizer/README
    src/backend/optimizer/plan/README
After that, start reading the code ...

            regards, tom lane

Re: looking for documentation about the optimizer

From
Bruce Momjian
Date:
Tom Lane wrote:
> "Alice Lottini" <alice_lottini@yahoo.it> writes:
> > Does anybody know where I can find some documentation about the PostgreSQL =
> > optimizer?
>
> Aside from the general info in the Developer's Guide, there are README
> files in the source tree that you should look at:
>     src/backend/optimizer/README
>     src/backend/optimizer/plan/README
> After that, start reading the code ...

And some papers on the web site in the Developer's Corner.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073