Scott Ribe <scott_r...@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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
