Re: XIDs and big boxes again ... - Mailing list pgsql-hackers

From Tom Lane
Subject Re: XIDs and big boxes again ...
Date
Msg-id 20230.1210524411@sss.pgh.pa.us
Whole thread Raw
In response to Re: XIDs and big boxes again ...  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: XIDs and big boxes again ...
List pgsql-hackers
Gregory Stark <stark@enterprisedb.com> writes:
> ... Keep in mind you're proposing to make everything run 3% slower instead of
> using that 3% i/o bandwidth headroom to run vacuum outside the critical path.

I think that's actually understating the problem.  Assuming this is a
64-bit machine (which it had better be, if you want XID to be 64 bits...)
then the effective increase in tuple header size is not just 12 bytes
but 16 bytes, due to alignment padding.  Greg's 3% overhead number is
only on-target if your average row width is presently about 530 bytes.
It could easily be a whole lot less than that, and the overhead
proportionally higher.
        regards, tom lane


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: Setting a pre-existing index as a primary key
Next
From: Hans-Juergen Schoenig
Date:
Subject: Re: XIDs and big boxes again ...