Horton

Re: [HACKERS] subselect and optimizer

Boersenspielteam <boersenspiel@vocalweb.de>

View thread
From: "Boersenspielteam" <boersenspiel@vocalweb.de>
To: hackers@postgreSQL.org
Date: 1998-04-10T22:30:53Z
Lists: pgsql-hackers 
Hi,

Vadim helped me with the patch for my query. 

But this patch still didn't help for a simple join without a where 
clause. The query plan says it uses two sequential scans, where 6.2.1 
uses two index scans.

Strange stuff.

Seems like more than one problem it the optimizer code ...


Ciao

Das Boersenspielteam.

---------------------------------------------------------------------------
                          http://www.boersenspiel.de
              	         Das Boersenspiel im Internet
             *Realitaetsnah*  *Kostenlos*  *Ueber 6000 Spieler*
---------------------------------------------------------------------------