Re: How much do the hint bits help?

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: How much do the hint bits help?
Дата
Msg-id 4D125AA1.8050602@enterprisedb.com
обсуждение исходный текст
Ответ на Re: How much do the hint bits help?  (Merlin Moncure <mmoncure@gmail.com>)
Ответы Re: How much do the hint bits help?  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
On 22.12.2010 18:12, Merlin Moncure wrote:
> On Wed, Dec 22, 2010 at 11:06 AM, Tom Lane<tgl@sss.pgh.pa.us>  wrote:
>> Merlin Moncure<mmoncure@gmail.com>  writes:
>>> well, simon's point that hint bits complicate checksum may nor may not
>>> be the case, but no hint bits = less i/o = less checksumming (unless
>>> you checksum around the hint bits).
>>
>> I think you're optimistically assuming the extra clog accesses don't
>> cost any I/O.
>
> right, but clog is much more highly packed which is both a good and a
> bad thing.

As a sidenote: note that the clog is not currently CRC'd.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


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

Предыдущее
От: Alex Hunsaker
Дата:
Сообщение: Re: plperlu problem with utf8
Следующее
От: Tom Lane
Дата:
Сообщение: Re: wCTE behaviour