Postgres Pro
Downloads
Home   >   mailing lists

Re: XID wraparound in 8.4 - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: XID wraparound in 8.4
Date
Msg-id 20090812002855.GM16362@alvh.no-ip.org
Whole thread Raw
In response to Re: XID wraparound in 8.4  (Anj Adu <fotographs@gmail.com>)
List pgsql-admin
Tree view 
Anj Adu escribió:
> So..we dont have to check the last XID value per table ?
>
> we have a very high volume data warehouse for which autovacuum is not
> suitable due to performance reasons. Can we track the last XID on a
> per-table basis ?

Sure, see pg_class.relfrozenxid

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-admin by date:

Previous
From: Tim Landscheidt
Date:
Subject: Re: insert a backslash into a bytea field?
Next
From: Anj Adu
Date:
Subject: Re: XID wraparound in 8.4