| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru> |
| Cc: | "Imai, Yoshikazu" <imai(dot)yoshikazu(at)jp(dot)fujitsu(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Locking B-tree leafs immediately in exclusive mode |
| Date: | 2018-07-26 21:29:53 |
| Message-ID: | CANP8+j+rK4JEwf_EiT5knG71N=iWmE-8KG5kB3xMkO-8R15Btg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 26 July 2018 at 20:59, Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru> wrote:
> Great, thank you! So, I think the regression is demystified. We can
> now conclude that on our benchmarks this patch doesn't cause
> performance regression larger than measurement error. But in some
> cases it shows huge performance benefit.
>
> So, I'm going to commit this, if no objections.
+1 to commit.
What will the commit message be?
For me, this is about reducing contention on index leaf page hotspots,
while at the same time reducing the path length of lock acquisition on
leaf pages
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2018-07-26 21:45:17 | Re: [HACKERS] Getting rid of "accept incoming network connections" prompts on OS X |
| Previous Message | Andres Freund | 2018-07-26 20:55:00 | Re: How can we submit code patches that implement our (pending) patents? |