Tom,
> 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 ...
--
--Josh
Josh Berkus
PostgreSQL @ Sun
San Francisco