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

From Josh Berkus
Subject Re: How much do the hint bits help?
Date
Msg-id 4D126E98.4050105@agliodbs.com
Whole thread Raw
In response to Re: How much do the hint bits help?  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Responses Re: How much do the hint bits help?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Certainly having a choice about configuring them would be a good
> addition in itself, e.g  for data warehousing use the hint bits can be a
> considerable impediment so the *ability* to not have them would be a
> huge advantage.

Would need to be a restart option, no?

Regarding the contention which Tom expects: the extra load on the CLOG
would be 100% reads, no?  If it's *all* reads, why would we have any
more contention than we have now?

--                                  -- Josh Berkus                                    PostgreSQL Experts Inc.
                        http://www.pgexperts.com
 


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: CRC checks WAS: How much do the hint bits help?
Next
From: Tom Lane
Date:
Subject: Re: How much do the hint bits help?