| From: | "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com> |
|---|---|
| To: | 'Andres Freund' <andres(at)anarazel(dot)de> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, "Imai, Yoshikazu" <imai(dot)yoshikazu(at)jp(dot)fujitsu(dot)com>, 'Simon Riggs' <simon(at)2ndquadrant(dot)com>, "David Rowley" <david(dot)rowley(at)2ndquadrant(dot)com>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | RE: Speed up transaction completion faster after many relations are accessed in a transaction |
| Date: | 2019-04-08 02:54:16 |
| Message-ID: | 0A3221C70F24FB45833433255569204D1FBF2CD5@G01JPEXMBYT05 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
From: 'Andres Freund' [mailto:andres(at)anarazel(dot)de]
> On 2019-04-08 02:28:12 +0000, Tsunakawa, Takayuki wrote:
> > I think the linked list of LOCALLOCK approach is natural, simple, and
> > good.
>
> Did you see that people measured slowdowns?
Yeah, 0.5% decrease with pgbench -M prepared -S (select-only), which feels like a somewhat extreme test case. And that might be within noise as was mentioned.
If we want to remove even the noise, we may have to think of removing the LocalLockHash completely. But it doesn't seem feasible...
Regards
Takayuki Tsunakawa
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2019-04-08 02:58:43 | Re: Speed up transaction completion faster after many relations are accessed in a transaction |
| Previous Message | 'Andres Freund' | 2019-04-08 02:40:12 | Re: Speed up transaction completion faster after many relations are accessed in a transaction |