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

From Tom Lane
Subject Re: XID wraparound and busy databases
Date
Msg-id 6537.1187194711@sss.pgh.pa.us
Whole thread Raw
In response to XID wraparound and busy databases  (Bruce Momjian <bruce@momjian.us>)
Responses Re: XID wraparound and busy databases  (Bruce Momjian <bruce@momjian.us>)
Re: XID wraparound and busy databases  (Heikki Linnakangas <heikki@enterprisedb.com>)
Re: XID wraparound and busy databases  ("Florian G. Pflug" <fgp@phlo.org>)
List pgsql-hackers
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?
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: [mmoncure@gmail.com: Re: [GENERAL] array_to_set functions]
Next
From: Heikki Linnakangas
Date:
Subject: Re: XID wraparound and busy databases