Postgres Pro
Downloads
Home   >   mailing lists

Re: XID wraparound and busy databases - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: XID wraparound and busy databases
Date
Msg-id 46C3278A.1050809@enterprisedb.com
Whole thread Raw
In response to XID wraparound and busy databases  (Bruce Momjian <bruce@momjian.us>)
Responses Re: XID wraparound and busy databases  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
Bruce Momjian wrote:
> Is enlarging the xid field something we should consider for 8.4?  Is the
> autovacuum I/O less then the extra I/O needed for an expanded xid fields
> on every row?

I doubt that's going to happen...

Maybe we can do something to reduce the xid consumption? For example,
reuse xids for read-only queries.

--  Heikki Linnakangas EnterpriseDB   http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: XID wraparound and busy databases
Next
From: Bruce Momjian
Date:
Subject: Re: XID wraparound and busy databases