Re: [HACKERS] subselect and optimizer - Mailing list pgsql-hackers

From Boersenspielteam
Subject Re: [HACKERS] subselect and optimizer
Date
Msg-id 199804102024.WAA20062@mail.vocalweb.de
Whole thread Raw
In response to Re: [HACKERS] subselect and optimizer  (t-ishii@sra.co.jp)
Responses Re: [HACKERS] subselect and optimizer
List 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*
---------------------------------------------------------------------------

pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: reverse file descriptor to a file name...
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] subselect and optimizer