Re: [PERFORM] Vacuum problems with 9.1

2012-08-27 Thread Craig Ringer
On 08/28/2012 12:33 PM, Nimesh Satam wrote: 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 can

Re: [PERFORM] Vacuum problems with 9.1

2012-08-27 Thread Pavan Deolasee
On Tue, Aug 28, 2012 at 10:03 AM, Nimesh Satam wrote: > 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

[PERFORM] Vacuum problems with 9.1

2012-08-27 Thread Nimesh Satam
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 ma