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

From Bruce Momjian
Subject Re: [HACKERS] subselect and optimizer
Date
Msg-id 199804102108.RAA05050@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] subselect and optimizer  ("Boersenspielteam" <boersenspiel@vocalweb.de>)
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 ...
>

But we didn't have subselcts in 6.2.1?

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

pgsql-hackers by date:

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