Re: XID wraparound in 8.4

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Anj Adu <fotographs(at)gmail(dot)com>
Cc: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>, pgsql-admin(at)postgresql(dot)org
Subject: Re: XID wraparound in 8.4
Date: 2009-08-12 00:28:55
Message-ID: 20090812002855.GM16362@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Anj Adu 2009-08-12 03:50:43 Re: XID wraparound in 8.4
Previous Message Tim Landscheidt 2009-08-11 23:17:04 Re: insert a backslash into a bytea field?