Re: How much do the hint bits help?

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: How much do the hint bits help?
Дата
Msg-id AANLkTi=Kxuzzcgpzg5i5buT0Ly+rpXdQeV0Uou4yDi9W@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How much do the hint bits help?  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-hackers
On Wed, Dec 22, 2010 at 11:12 AM, Merlin Moncure <mmoncure@gmail.com> 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.  my conjecture here is that jamming the clog files is
> actually good, because that keeps them 'hot' and more than compensates
> the extra heap i/o.  the extra lock of course is scary.

er, should have said, plus less heap i/o compensates the extra clog i/o.

merlin


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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: How much do the hint bits help?
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: SQL/MED - core functionality