Re: How much do the hint bits help?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: How much do the hint bits help?
Date: 2010-12-22 21:54:12
Message-ID: 10934.1293054852@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Josh Berkus <josh(at)agliodbs(dot)com> writes:
> 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?

Read involves sharelock which still causes contention. Those bufmgr
contention storms we saw before were completely independent of whether
the pages were accessed for read or for write.

Another thing to keep in mind is that the current clog access code is
designed on the assumption that there's considerable locality of access
to pg_clog, ie, you usually only need to consult it for recent XIDs
because older ones have been hinted. Turn off hint bits, that behavior
goes out the window.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dimitri Fontaine 2010-12-22 22:05:55 Re: How much do the hint bits help?
Previous Message Josh Berkus 2010-12-22 21:33:12 Re: How much do the hint bits help?