Re: How to avoid transaction ID wrap

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: Trent Shipley <tshipley(at)deru(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: How to avoid transaction ID wrap
Date: 2006-06-10 18:29:48
Message-ID: 1675.1149964188@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> That's why people suggest partitions. Then you only vacuum the
> partitions that are new and the old ones never need to be touched...

This will all work a lot better once we track XID wraparound risk on a
per-table rather than per-database basis. I hope that will be done in
time for 8.2.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stefan Kaltenbrunner 2006-06-10 19:10:09 Re: bison version
Previous Message ohp 2006-06-10 18:26:48 bison version