From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | rick(at)chapwin(dot)com (Rick Windham) |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] New to PostgreSQL Question (Query Optimizer) |
Date: | 1998-02-19 21:43:21 |
Message-ID: | 199802192143.QAA14865@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>
> Hello,
> I'm newly into PostgreSQL from a SYBASE world and I haven't had a lot of
> time to get into the code, so bare with me please.
> Is there a query optimizer in PostgreSQL? or if not are there plans for
> one? And are there plans for anything like clustered indexes?
> I'm curious because one of the jobs I almost took a few years ago was
> working on the query optimizer itself. And please forgive me current
> ignorance of the architecture of your engine.
We have a first-class optimizer. If you look in the current sources,
the optimizer directory has a README that describes some of it. You
will need the 6.3/snapshot release from ftp.postgresql.org to see the
README, or go to www.postgresql.org, and go to support/documentation,
and choose the nice program flowchart. You can cruise around in there,
and see the source and README's.
--
Bruce Momjian
maillist(at)candle(dot)pha(dot)pa(dot)us
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-02-19 21:48:26 | atttypmod |
Previous Message | Keith Parks | 1998-02-19 21:40:14 | ecpg error (19th Feb cvsup) |