Re: How much do the hint bits help? - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: How much do the hint bits help?
Date
Msg-id AANLkTi=Kxuzzcgpzg5i5buT0Ly+rpXdQeV0Uou4yDi9W@mail.gmail.com
Whole thread Raw
In response to Re: How much do the hint bits help?  (Merlin Moncure <mmoncure@gmail.com>)
List 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 by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: How much do the hint bits help?
Next
From: Simon Riggs
Date:
Subject: Re: SQL/MED - core functionality