Re: GSoC 2017 Proposal for "Explicitly support predicate locks in index access methods besides btree"

From: Kevin Grittner <kgrittn(at)gmail(dot)com>
To: Shubham Barai <shubhambaraiss(at)gmail(dot)com>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, pgsql-students(at)postgresql(dot)org
Subject: Re: GSoC 2017 Proposal for "Explicitly support predicate locks in index access methods besides btree"
Date: 2017-03-30 15:55:23
Message-ID: CACjxUsMzSeVJ6mrxnH8ocdJyDuakoZPD=etVAk=bNS83UaE9Rg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-students

On Tue, Mar 28, 2017 at 12:36 PM, Shubham Barai
<shubhambaraiss(at)gmail(dot)com> wrote:

> * Hash Index

> currently, I am trying to understand how the splitting of bucket works.
> should we acquire predicate lock on every page from an old and new bucket in
> case there is a predicate lock on a page of an old bucket?

For page level locking in hash indexes, I think it might be fine to
lock the first page of a bucket.

Also, in case you missed it, here are some guidelines I suggested.
There weren't any comments, which means they probably didn't offend
anyone else too badly. They're just my opinion, but you might want
to consider them:

Each GSoC student proposal should be a PDF file of 6 to 8 pages. In
the end, Google will publish these documents on a web page, so the
student should make each proposal something which they will be happy
to have future potential employers review.

Some ideas for desirable content:

- A resume or CV of the student, including any prior GSoC work
- Their reasons for wanting to participate
- What else they have planned for the summer, and what their time
commitment to the GSoC work will be
- A clear statement that there will be no intellectual property
problems with the work they will be doing -- that the PostgreSQL
community will be able to use their work without encumbrances
(e.g., there should be no agreements related to prior or
ongoing work which might assign the rights to the work they do
to someone else)
- A description of what they will do, and how
- Milestones with dates
- What they consider to be the test that they have successfully
completed the project

--
Kevin Grittner

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Devrim Gündüz 2017-03-30 16:03:27 Re: PDF build is broken
Previous Message Robert Haas 2017-03-30 15:50:59 Re: Patch: Write Amplification Reduction Method (WARM)

Browse pgsql-students by date

  From Date Subject
Next Message Arseny Sher 2017-04-01 21:13:15 Re: [GSoC] Push-based query executor discussion
Previous Message Kevin Grittner 2017-03-30 15:47:00 Re: [pgsql-students] GSoC 2017 Proposal for "Explicitly support predicate locks in index access methods besides btree"