Re: PostgreSQL internals. Help needed

It'd be great if on completion, you can publish the furnished ERD of the
catalog structure, and other representation of the planner, optimizer etc.

Luckys.

On 5/22/06, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote:
>
>
> Please read the developer's FAQ on our web site. In fact the entire
> developers section will help you.
>
>
> ---------------------------------------------------------------------------
>
> Federico Petronio wrote:
> > Hello all,
> >
> > as part of an University assignment, a group friends and I have to
> > research in PostgreSQL internals (i.e. parsing, optimizing, execution
> > planning, etc) and compare it with other DBMS (an educational oriented
> > one called MiniBase). I would like to know is you can point us to a
> > place where we can find that kind of information.
> >
> > We need to understand how the parser, the optimizer, the execution
> > planner works and the go to the source code and find where and how each
> > functionality is implemented. We need also to understand the structure
> > of the catalog (and make an ERD for it) and how PostgreSQL use it during
> > queries. We will also appreciate any link to detailed explanation of the
> > source code.
> >
> > We don?t know if this kind of information if available online, or if
> > there are books out there about it, So any help would be very
> appreciated.
> >
> > Thank you!
> > --
> >
> > Federico Petronio
> > petrus(at)activesec(dot)biz
> > Linux User #129974
> >
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/docs/faq
> >
>
> --
> Bruce Momjian http://candle.pha.pa.us
> EnterpriseDB http://www.enterprisedb.com
>
> + If your life is a hard drive, Christ can be your backup. +
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--
regards, Luckys...