Joseph Shraibman <jks(at)selectacast(dot)net> writes:
> My update looks like:
> UPDATE tablename SET intfield = 2 WHERE keyfield IN( ... )
> If I lowered the number of items in the IN() then I didn't get the error, but what that
> number is is a moving target. 205 used to work a few minutes ago, but now 200 doesn't
> work. A vaccuum seems to help matters. In previous versions of postgres I was able to do
> up to 10000.
Can we see the EXPLAIN plan for the failing update?
Also, I've forgotten exactly which PG version you're using?
regards, tom lane