Postgres Pro
Downloads
Home   >   mailing lists

Re: How to avoid transaction ID wrap - Mailing list pgsql-hackers

From Tom Lane
Subject Re: How to avoid transaction ID wrap
Date
Msg-id 1675.1149964188@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to avoid transaction ID wrap  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: How to avoid transaction ID wrap  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Tree view 
Martijn van Oosterhout <kleptog@svana.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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: TODO: Add pg_get_acldef(), pg_get_typedefault(), pg_get_attrdef(), pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef()
Next
From: Tom Lane
Date:
Subject: Re: That EXPLAIN ANALYZE patch still needs work