Re: Too coarse predicate locks granularity for B+ tree indexes

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: Andrey Borodin <amborodin86(at)gmail(dot)com>
Cc: Rinat Shigapov <rinatshigapov(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Too coarse predicate locks granularity for B+ tree indexes
Date: 2023-02-07 21:51:08
Message-ID: CA+hUKGLyj1Rt6stXaksz=Xe0=TPPypQ4QwWTrQNSds=aFAfgfQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Wed, Feb 8, 2023 at 10:44 AM Thomas Munro <thomas(dot)munro(at)gmail(dot)com> wrote:
> On Wed, Feb 8, 2023 at 5:25 AM Andrey Borodin <amborodin86(at)gmail(dot)com> wrote:
> > On Tue, Feb 7, 2023 at 4:01 AM Rinat Shigapov <rinatshigapov(at)gmail(dot)com> wrote:
> > > Thomas, thank you for the details!
> > >
> > > Have you kept the branch that you used to generate the patch? Which commit should the patch apply to?
> >
> > You can try something like
> > git checkout 'master(at){2018-05-13 13:37:00}'
> > to get a commit by date from rev-parse.
>
> I don't have time to work on this currently but if Rinat or others
> want to look into it... maybe I should rebase that experiment on top
> of current master. Here's the branch:
>
> https://github.com/macdice/postgres/tree/ssi-index-locking-refinements

Erm, I guess I should also post the rebased patches here, for the
mailing list archives.

Attachment Content-Type Size
v5-0001-Use-tuple-level-SIREAD-locks-for-index-only-scans.patch text/x-patch 6.7 KB
v5-0002-WIP-Skip-SIREAD-locks-on-btree-pages-when-possibl.patch text/x-patch 32.7 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message sunyucong@gmail.com 2023-02-07 23:38:13 Need help debugging slow logical replication
Previous Message Thomas Munro 2023-02-07 21:44:36 Re: Too coarse predicate locks granularity for B+ tree indexes

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2023-02-07 21:56:55 Re: Non-superuser subscription owners
Previous Message Thomas Munro 2023-02-07 21:44:36 Re: Too coarse predicate locks granularity for B+ tree indexes