Postgres Pro
Downloads
Home   >   mailing lists

Re: VACUUM FULL needed sometimes to prevent transaction - Mailing list pgsql-performance

From Heikki Linnakangas
Subject Re: VACUUM FULL needed sometimes to prevent transaction
Date
Msg-id 44EC56F5.50704@enterprisedb.com
Whole thread Raw
In response to Re: VACUUM FULL needed sometimes to prevent transaction  (Markus Schaber <schabi@logix-tt.com>)
List pgsql-performance
Tree view 
Markus Schaber wrote:
> I just asked myself whether a 2-phase-commit transaction that was
> prepared, but never committed, can block vacuuming and TID recycling.
>

Yes.

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

pgsql-performance by date:

Previous
From: Markus Schaber
Date:
Subject: Re: VACUUM FULL needed sometimes to prevent transaction
Next
From: "Subbiah, Stalin"
Date:
Subject: Re: Query tuning