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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly