Re: CacheInvalidateRelcache in btree is a crummy idea - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: CacheInvalidateRelcache in btree is a crummy idea
Date
Msg-id 52F1F9E4.9050808@vmware.com
Whole thread Raw
In response to CacheInvalidateRelcache in btree is a crummy idea  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: CacheInvalidateRelcache in btree is a crummy idea  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 02/02/2014 11:45 PM, Tom Lane wrote:
> So I'm thinking my commit d2896a9ed, which introduced this mechanism,
> was poorly thought out and we should just remove the relcache invals
> as per the attached patch.  Letting _bt_getroot() update the cached
> metapage at next use should be a lot cheaper than a full relcache
> rebuild for the index.

Looks good to me.

- Heikki



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Re: Misaligned BufferDescriptors causing major performance problems on AMD
Next
From: Heikki Linnakangas
Date:
Subject: Re: Performance Improvement by reducing WAL for Update Operation