Re: Change behavior of (m)xid_age - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Change behavior of (m)xid_age
Date
Msg-id CA+Tgmoau5wDW+qNo-N_4F+2B2cLNDyamxPmXg+vEh20mai1Feg@mail.gmail.com
Whole thread Raw
In response to Re: Change behavior of (m)xid_age  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-hackers
On Thu, Oct 22, 2015 at 6:57 PM, Jim Nasby <Jim.Nasby@bluetreble.com> wrote:
> Is there no case where it can be a permanent XID for a table or toast table?

I don't think so.

> The other issue is relminmxid, which if you're looking at relfrozenxid you'd
> want to look at as well. So you can't do a simple WHERE here.

I don't really know what you're referring to here, but it doesn't sound serious.

> Perhaps a better way to handle this is to just add correctly computed age
> fields to pg_stat_all_tables and pg_stat_database.

I'll defer to others on that point.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Re: [BUGS] BUG #13611: test_postmaster_connection failed (Windows, listen_addresses = '0.0.0.0' or '::')
Next
From: David Fetter
Date:
Subject: Re: Making tab-complete.c easier to maintain