Re: Plans for solving the VACUUM problem

Поиск
Список
Период
Сортировка
От Lincoln Yeoh
Тема Re: Plans for solving the VACUUM problem
Дата
Msg-id 3.0.5.32.20010521092806.01069d40@192.228.128.13
обсуждение исходный текст
Ответ на Re: Plans for solving the VACUUM problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
At 01:09 PM 20-05-2001 -0400, Tom Lane wrote:
>>> 3. Reusing xact IDs would be nice, but there's an answer with a lot less
>>> impact on the system: go to 8-byte xact IDs.
>
>> +8 bytes in tuple header is not so tiny thing.
>
>Agreed, but the people who need 8-byte IDs are not running small
>installations.  I think they'd sooner pay a little more in disk space
>than risk costs in performance or reliability.

An additional 4 (8?) bytes per tuple to increase the "mean time before
problem " 4 billion times sounds good to me.

Cheerio,
Link.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: mlw
Дата:
Сообщение: Index and functions
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: RE: Updating system catalogs after a tuple deletion