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.
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
------------------------------------------------------------------
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