Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group