Skip site navigation (1) Skip section navigation (2)

Vacuum problems with 9.1

From: Nimesh Satam <nimesh(dot)zedo(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Vacuum problems with 9.1
Date: 2012-08-28 04:33:00
Message-ID: CACemtiN4fMC1Xgbuh=Tdr7fWP_4GqLgYnd=nacz9xHbH7VDFMQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hi,

We have been using the current version of postgres i.e. 9.1.4 with
streaming replication on. While vacuuming we noticed that certain dead rows
are not getting removed and following debug information is printed:

"DETAIL: 12560 dead row versions cannot be removed yet."

As per suggestion, we made sure that no long running transactions are
active. Also all the applications were stopped during this time.

Can anybody highlight the possible reason for the dead rows not been
cleaned?

FYI: We used the command VACUUM FULL ANALYZE VERBOSE table_name; command.

Regards,
Nimesh.

Responses

pgsql-performance by date

Next:From: Liron ShiriDate: 2012-08-28 06:24:15
Subject: Re: Investigating the reason for a very big TOAST table size
Previous:From: Daniel FarinaDate: 2012-08-27 16:42:19
Subject: Re: Investigating the reason for a very big TOAST table size

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group