Re: About method of PostgreSQL's Optimizer

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: pryscila(dot)lista(at)gmail(dot)com, pgsql-performance(at)postgresql(dot)org
Subject: Re: About method of PostgreSQL's Optimizer
Date: 2005-09-14 02:26:58
Message-ID: 28318.1126664818@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

Neil Conway <neilc(at)samurai(dot)com> writes:
> Pryscila B Guttoski wrote:
>> On my master course, I'm studying the PostgreSQL's optimizer.
>> I don't know if anyone in this list have been participated from the
>> PostgreSQL's Optimizer development, but maybe someone can help me on this
>> question.

> pgsql-hackers might be more appropriate.

AFAIK the basic code goes back to Berkeley days. Elein might possibly
remember something about it, but no one else that's on the project now
was involved then. The right place to look would be in the Berkeley
project's publications:

http://db.cs.berkeley.edu//papers/

I agree with Neil's point that it's a spiritual descendant of System R
and there's plenty of material about that in the general database
literature.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-09-14 02:42:59 Re: Spinlocks, yet again: analysis and proposed patches
Previous Message Neil Conway 2005-09-14 02:17:27 8.1 system info / admin functions

Browse pgsql-performance by date

  From Date Subject
Next Message Jonah H. Harris 2005-09-14 03:08:31 Re: About method of PostgreSQL's Optimizer
Previous Message Neil Conway 2005-09-14 01:34:50 Re: About method of PostgreSQL's Optimizer