What does “Recheck Cond” in Explain result mean?

This was explained by Tom Lane on the mailing list:

what is “Recheck condition” and why is it needed?

If the bitmap gets too large we convert it to “lossy” style, in which we
only remember which pages contain matching tuples instead of remembering
each tuple individually. When that happens, the table-visiting phase
has to examine each tuple on the page and recheck the scan condition to
see which tuples to return.

Leave a Comment

tech