Re: Scaling shared buffer eviction - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Scaling shared buffer eviction
Date
Msg-id 54255666.4080101@vmware.com
Whole thread Raw
In response to Re: Scaling shared buffer eviction  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: Scaling shared buffer eviction  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
On 09/25/2014 05:40 PM, Andres Freund wrote:
> There's two reasons for that: a) dynahash just isn't very good and it
> does a lot of things that will never be necessary for these hashes. b)
> the key into the hash table is*far*  too wide. A significant portion of
> the time is spent comparing buffer/lock tags.

Hmm. Is it the comparing, or calculating the hash? We could precalculate 
the hash for RelFileNode+ForkNumber, and store it RelationData. At a 
lookup, you'd only need to mix in the block number.

- Heikki




pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Scaling shared buffer eviction
Next
From: Heikki Linnakangas
Date:
Subject: Re: delta relations in AFTER triggers