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

From Heikki Linnakangas
Subject Re: How much do the hint bits help?
Date
Msg-id 4D125AA1.8050602@enterprisedb.com
Whole thread Raw
In response to Re: How much do the hint bits help?  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: How much do the hint bits help?  (Simon Riggs <simon@2ndQuadrant.com>)
List 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 by date:

Previous
From: Alex Hunsaker
Date:
Subject: Re: plperlu problem with utf8
Next
From: Tom Lane
Date:
Subject: Re: wCTE behaviour