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.

Thanks, Rick.
+-------------------------------------------+
| "No matter where you go...there you are." |
|ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ -Buckaroo Banzaiï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ |
+-------------------------------------------+---------------------
ChapWin Consulting Inc.ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ rick@chapwin.com
Red Lake Internet / Earfalls Internetï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ www.chapwin.net
Box 882ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ (807) 727-2606
Red Lake, ON P0V 2M0ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ FAX (807) 727-3594
------------------------------------------------------------------


Thu, 19 Feb 1998 15:35:16 -0600
"Rick Windham" <rick@chapwin.com>
New to PostgreSQL Question (Query Optimizer)
> 
> 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@candle.pha.pa.us

Thu, 19 Feb 1998 16:43:21 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] New to PostgreSQL Question (Query Optimizer)