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 |
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 |
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 |