John R Pierce <pierce@xxxxxxxxxxxx> writes: > On 10/29/2013 12:41 PM, Gregory Haase wrote: >> db_name=# VACUUM FULL VERBOSE table_schema.table_name; >> INFO: vacuuming "table_schema.table_name" >> INFO: "table_name": found 2 removable, 29663 nonremovable row >> versions in 1754 pages >> DETAIL: 0 dead row versions cannot be removed yet. >> CPU 0.07s/0.10u sec elapsed 0.30 sec. > is there an old transaction pending? that 'masks' vacuum from touching > any tuples newer than the start of that transaction. If old transactions were the problem, vacuum would be reporting that some-large-number of dead row versions couldn't be removed yet. There doesn't seem to be anything obviously wrong here. 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
