Re: [HACKERS] Cache Hash Index meta page. - Mailing list pgsql-hackers

From Mithun Cy
Subject Re: [HACKERS] Cache Hash Index meta page.
Date
Msg-id CAD__Ouj6mjce+5HimfJHoy+KeEK9GkXYOtJPcwvZVi7_nNrX=A@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Cache Hash Index meta page.  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: [HACKERS] Cache Hash Index meta page.  (Mithun Cy <mithun.cy@enterprisedb.com>)
Re: [HACKERS] Cache Hash Index meta page.  (Amit Kapila <amit.kapila16@gmail.com>)
Re: [HACKERS] Cache Hash Index meta page.  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Thu, Dec 22, 2016 at 12:17 PM, Amit Kapila <amit.kapila16@gmail.com> wrote:
> On Wed, Dec 21, 2016 at 9:26 PM, Robert Haas <robertmhaas@gmail.com> wrote:
>> On Tue, Dec 20, 2016 at 2:25 PM, Mithun Cy <mithun.cy@enterprisedb.com> wrote:
>>> -- I think if it is okay, I can document same for each member of HashMetaPageData whether to read from cached from
metapage or directly from current meta page. Below briefly I have commented for each member. If you suggest I can go
withthat approach, I will produce a neat patch for same. 
>>
>> Plain text emails are preferred on this list.

Sorry, I have set the mail to plain text mode now.

> I think this will make metpage cache access somewhat
> similar to what we have in btree where we use cache to access
> rootpage.  Will something like that address your concern?

Thanks, just like _bt_getroot I am introducing a new function
_hash_getbucketbuf_from_hashkey() which will give the target bucket
buffer for the given hashkey. This will use the cached metapage
contents instead of reading meta page buffer if cached data is valid.
There are 2 places which can use this service 1. _hash_first and 2.
_hash_doinsert.

--
Thanks and Regards
Mithun C Y
EnterpriseDB: http://www.enterprisedb.com

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Attachment

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: [HACKERS] merging some features from plpgsql2 project
Next
From: Mithun Cy
Date:
Subject: Re: [HACKERS] Cache Hash Index meta page.