Kevin Kempter <kevink@xxxxxxxxxxxxxxxxxxx> wrote: > INFO: "action_rollup_notifier": found 0 removable, 34391214 > nonremovable row versions in 152175 pages > DETAIL: 22424476 dead row versions cannot be removed yet. > There were 0 unused item pointers. > 2 pages contain useful free space. > 0 pages are entirely empty. > Anyone have any suggestions per why these rows cannot be removed > yet? The only time I've seen numbers like that is when there was a long-running transaction which was preventing VACUUM from cleaning anything up. (In our case it was a programmer using an unapproved tool against a production server; the tool issued a BEGIN TRANSACTION and just sat there.) Look at the pg_stat_activity table. If you have any values in xact_start more than a few seconds old, you've identified your culprit. I'm betting it will be "idle in transaction". -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
