Re: Optimizing Update with WHERE x IN (id1,id2,...)

Michael Monnerie <michael.monnerie@is.it-management.at> writes:
> I just saw this EXPLAIN in PostgreSQL 8.3.12:
> [ just like any other bitmap index scan ]
> And it seems to me that could be optimized to skip the "Recheck Cond" as
> that is already checked by the Index Scan?  Should save some CPU cycles.

You evidently don't understand what that's for.  In typical cases it's
not rechecked.  The recheck condition is only applied if the index scan
becomes lossy.

            regards, tom lane