Re: autovacuum and transaction id wraparound

From: pawel_kukawski <kukismen(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: autovacuum and transaction id wraparound
Date: 2012-03-09 07:15:05
Message-ID: 1331277305706-5549786.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Jens,

Thanks for answer. One more question:

Can the manual VACUUM operate on database where there are long lasting
transactions?

In other words, do I need to restart the server or kill long lasting
transactions in order to allow manual VACUUM to clear old XIDs?

Regards,
Pawel

--
View this message in context: http://postgresql.1045698.n5.nabble.com/autovacuum-and-transaction-id-wraparound-tp5545412p5549786.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2012-03-09 07:48:10 Re: How to erase transaction logs on PostgreSQL
Previous Message Frank Church 2012-03-09 00:09:27 Re: How to erase transaction logs on PostgreSQL