Hi, tom wrote:
Initially it seems that the WHERE IN (...) approach takes a turn for the worse when the list gets very large.
What version do you use? PostgreSQL 8.2 had great improvements for that specific issue. Did you try EXPLAIN?
Regards Markus ---------------------------(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