Re: XIDs and big boxes again ...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: XIDs and big boxes again ...
Дата
Msg-id 20230.1210524411@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: XIDs and big boxes again ...  (Gregory Stark <stark@enterprisedb.com>)
Ответы Re: XIDs and big boxes again ...  (Hans-Juergen Schoenig <postgres@cybertec.at>)
Список 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 по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: Setting a pre-existing index as a primary key
Следующее
От: Hans-Juergen Schoenig
Дата:
Сообщение: Re: XIDs and big boxes again ...