On 08/28/2012 12:33 PM, Nimesh Satam wrote:
> 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
I don't know if prepared transactions could cause this exact message,
select * from pg_prepared_xacts ;
to see if you have any prepared transactions (from two-phase commit)
If you don't use XA or 2PC, consider setting max_prepared_transactions
to 0 in postgresql.conf if it isn't already.
In response to
pgsql-performance by date
|Next:||From: Pavan Deolasee||Date: 2012-08-28 07:11:16|
|Subject: Re: Execution from java - slow|
|Previous:||From: Pavan Deolasee||Date: 2012-08-28 06:33:13|
|Subject: Re: Vacuum problems with 9.1|