akp geek <akpgeek@xxxxxxxxx> writes: > * "Orders": found 0 removable, 27164544 nonremovable row versions in 518971 > pages* > *DETAIL: 27126176 dead row versions cannot be removed yet.* So there isn't anything vacuum can do right now. You've apparently got an old open transaction, which is blocking vacuum from removing those dead rows because the open transaction should still be able to see them if it were to look. You need to close that transaction, and then do a vacuum full (and probably a reindex after that). 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
