Postgres Pro
Downloads
Home   >   mailing lists

Vacuum problems with 9.1 - Mailing list pgsql-performance

From Nimesh Satam
Subject Vacuum problems with 9.1
Date
Msg-id CACemtiN4fMC1Xgbuh=Tdr7fWP_4GqLgYnd=nacz9xHbH7VDFMQ@mail.gmail.com
Whole thread Raw
Responses Re: Vacuum problems with 9.1  (Pavan Deolasee <pavan.deolasee@gmail.com>)
Re: Vacuum problems with 9.1  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-performance
Tree view
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.

pgsql-performance by date:

Previous
From: Daniel Farina
Date:
Subject: Re: Investigating the reason for a very big TOAST table size
Next
From: Liron Shiri
Date:
Subject: Re: Investigating the reason for a very big TOAST table size