Re:

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Michael Rothschild" <michael(dot)r(at)corigin(dot)co(dot)il>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re:
Date: 2003-12-25 16:28:54
Message-ID: 20565.1072369734@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Michael Rothschild" <michael(dot)r(at)corigin(dot)co(dot)il> writes:
> Based on what I saw (and maybe I didn't see enough) it seems that the
> optimizer will always decide to repeatedly scan the whole row set
> returned by sub selects in the context of an IN clause sequentially,

What version were you looking at?

regards, tom lane

In response to

  • at 2003-12-24 16:25:43 from Michael Rothschild

Browse pgsql-performance by date

  From Date Subject
Next Message Keith Bottner 2003-12-27 00:11:19 What's faster?
Previous Message Christopher Kings-Lynne 2003-12-25 02:47:28 Re: