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

From Bruce Momjian
Subject Re: XID wraparound and busy databases
Date
Msg-id 200708151620.l7FGK3H07904@momjian.us
Whole thread Raw
In response to Re: XID wraparound and busy databases  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > Is enlarging the xid field something we should consider for 8.4?
> 
> No.  We just got the tuple header down to 24 bytes, we are not going
> to give that back and then some.
> 
> If you are processing 6K transactions per second, you can afford to
> vacuum every couple days... and probably need to vacuum much more often
> than that anyway, to avoid table bloat.
> 
> Possibly your respondent should think about trying to do more than one
> thing per transaction?

OK, yea, I think that makes sense.

--  Bruce Momjian  <bruce@momjian.us>          http://momjian.us EnterpriseDB
http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: XID wraparound and busy databases
Next
From: "Marc G. Fournier"
Date:
Subject: Re: CVS corruption/mistagging?