From: Tom Lane <tgl@sss.pgh.pa.us>
To: Manfred Spraul <manfred@colorfullife.com>
Cc: neilc@samurai.com
Cc: markw@osdl.org
Cc: pgsql-performance@postgresql.org
Subject: Re: futex results with dbt-3
Date: Mon, 25 Oct 2004 13:45:28 -0400
Message-ID: <21743.1098726328@sss.pgh.pa.us> (raw)
In-Reply-To: <417D383E.1010807@colorfullife.com>
References: <417221B5.1050704@colorfullife.com>
<20151.1098222733@sss.pgh.pa.us>
<417697A5.1050600@colorfullife.com>
<7178.1098292535@sss.pgh.pa.us>
<4176A2C1.3070205@colorfullife.com>
<21093.1098722706@sss.pgh.pa.us>
<417D383E.1010807@colorfullife.com>
Manfred Spraul <manfred@colorfullife.com> writes:
> Tom Lane wrote:
>> It could be that I'm all wet and there is no relationship between the
>> cache line thrashing and the seemingly excessive BufMgrLock contention.
>>
> Is it important? The fix is identical in both cases: per-bucket locks
> for the hash table and a buffer aging strategy that doesn't need one
> global lock that must be acquired for every lookup.
Reducing BufMgrLock contention is a good idea, but it's not really my
idea of a fix for this issue. In the absence of a full understanding,
we may be fixing the wrong thing. It's worth remembering that when we
first hit this issue, I made some simple changes that approximately
halved the number of BufMgrLock acquisitions by joining ReleaseBuffer
and ReadBuffer calls into ReleaseAndReadBuffer in all the places in the
test case's loop. This made essentially no change in the CS storm
behavior :-(. So I do not know how much contention we have to get rid
of to get the problem to go away, or even whether this is the right path
to take.
(I am unconvinced that either of those specific suggestions is The Right
Way to break up the bufmgrlock, either, but that's a different thread.)
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, manfred@colorfullife.com, neilc@samurai.com, markw@osdl.org
Subject: Re: futex results with dbt-3
In-Reply-To: <21743.1098726328@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox