Re: futex results with dbt-3 - Mailing list pgsql-performance

From Manfred Spraul
Subject Re: futex results with dbt-3
Date
Msg-id 417D383E.1010807@colorfullife.com
Whole thread Raw
In response to Re: futex results with dbt-3  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
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.

--
    Manfred

pgsql-performance by date:

Previous
From: Markus Bertheau
Date:
Subject: Re: can't handle large number of INSERT/UPDATEs
Next
From: TTK Ciar
Date:
Subject: psql large RSS (1.6GB)