Re: [HACKERS] subselect and optimizer

From: "Boersenspielteam" <boersenspiel(at)vocalweb(dot)de>
To: hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] subselect and optimizer
Date: 1998-04-10 22:30:53
Message-ID: 199804102024.WAA20062@mail.vocalweb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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*
---------------------------------------------------------------------------

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-04-10 22:57:47 Re: [HACKERS] reverse file descriptor to a file name...
Previous Message The Hermit Hacker 1998-04-10 22:03:07 Re: [HACKERS] reverse file descriptor to a file name...