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

Re: VACUUM FULL needed sometimes to prevent transaction

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: Markus Schaber <schabi(at)logix-tt(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: VACUUM FULL needed sometimes to prevent transaction
Date: 2006-08-23 13:24:05
Message-ID: 44EC56F5.50704@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-performance
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


In response to

pgsql-performance by date

Next:From: Subbiah, StalinDate: 2006-08-23 18:02:35
Subject: Re: Query tuning
Previous:From: Markus SchaberDate: 2006-08-23 12:50:54
Subject: Re: VACUUM FULL needed sometimes to prevent transaction

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