> I think it's pretty much done. Try WHERE foo IN (VALUES (1),(2),...)
> if you have so many values that a non-nestloop join seems indicated.
Hmmm. Was there a reason not to automate this? Thread link is fine if
you can remember the subject line ... I can't find it on archives.
> The plain non-VALUES list form is also significantly faster than it
> was, but I think it will only result in a bitmap indexscan plan type.
Yeah, even bitmapscans break down at 1000 values ...
PostgreSQL @ Sun
In response to
pgsql-hackers by date
|Next:||From: Henry B. Hotz||Date: 2006-11-01 00:14:17|
|Subject: Design Considerations for New Authentication Methods|
|Previous:||From: Tom Lane||Date: 2006-10-31 21:44:44|
|Subject: Re: zic data updates |