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