Scott Ribe <scott_ribe@elevated-dev.com> writes:
> I hit this peculiar result last night with 9.1.3 (Intel, 64-bit). Check out the query and the explain analyze
results:
Apparently a lot of dead rows with end_when > now are still there.
Autovacuum disabled, perhaps? Open prepared transactions? It
might be interesting to do a manual VACUUM VERBOSE on the table
and see how many rows it reports reclaiming.
regards, tom lane