Postgres Pro
Downloads
Home   >   mailing lists

RE: Speed up transaction completion faster after many relations areaccessed in a transaction - Mailing list pgsql-hackers

From Tsunakawa, Takayuki
Subject RE: Speed up transaction completion faster after many relations areaccessed in a transaction
Date
Msg-id 0A3221C70F24FB45833433255569204D1FBF2CD5@G01JPEXMBYT05
Whole thread Raw
In response to Re: Speed up transaction completion faster after many relations areaccessed in a transaction  ('Andres Freund' <andres@anarazel.de>)
Responses Re: Speed up transaction completion faster after many relations areaccessed in a transaction
List pgsql-hackers
Tree view 
From: 'Andres Freund' [mailto:andres@anarazel.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
mightbe 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
seemfeasible...
 


Regards
Takayuki Tsunakawa

pgsql-hackers by date:

Previous
From: 'Andres Freund'
Date:
Subject: Re: Speed up transaction completion faster after many relations areaccessed in a transaction
Next
From: David Rowley
Date:
Subject: Re: Speed up transaction completion faster after many relations areaccessed in a transaction