Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
