Re: Improving connection scalability: GetSnapshotData() - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Improving connection scalability: GetSnapshotData()
Date
Msg-id F0E7D264-FEA3-47D3-815E-C834569EBCDA@anarazel.de
Whole thread Raw
In response to Re: Improving connection scalability: GetSnapshotData()  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
Responses Re: Improving connection scalability: GetSnapshotData()  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Re: Improving connection scalability: GetSnapshotData()  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
List pgsql-hackers
Hi,

On March 29, 2020 11:24:32 AM PDT, Alexander Korotkov <a.korotkov@postgrespro.ru> wrote:
> clearly a big win on majority
>of workloads, I think we still need to investigate different workloads
>on different hardware to ensure there is no regression.

Definitely. Which workloads are you thinking of? I can think of those affected facets: snapshot speed, commit speed
withwrites, connection establishment, prepared transaction speed. All in the small and large connection count cases. 

I did measurements on all of those but prepared xacts, fwiw. That definitely needs to be measured, due to the locking
changesaround procarrayaddd/remove. 

I don't think regressions besides perhaps 2pc are likely - there's nothing really getting more expensive but procarray
add/remove.


Andres

Regards,

Andres


--
Sent from my Android device with K-9 Mail. Please excuse my brevity.



pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: Improving connection scalability: GetSnapshotData()
Next
From: Stephen Frost
Date:
Subject: Re: GSoC Proposal