Postgres Pro
Downloads
Home   >   mailing lists

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

From Andres Freund
Subject Re: Improving connection scalability: GetSnapshotData()
Date
Msg-id 20200301084638.7hfktq4sh2mcnuen@alap3.anarazel.de
Whole thread Raw
In response to Improving connection scalability: GetSnapshotData()  (Andres Freund <andres@anarazel.de>)
Responses Re: Improving connection scalability: GetSnapshotData()  (Amit Kapila <amit.kapila16@gmail.com>)
Re: Improving connection scalability: GetSnapshotData()  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-hackers
Tree view 
Hi,

On 2020-03-01 00:36:01 -0800, Andres Freund wrote:
> conns   tps master        tps pgxact-split
> 
> 1       26842.492845            26524.194821
> 10      246923.158682           249224.782661
> 50      695956.539704           709833.746374
> 100     1054727.043139          1903616.306028
> 200     964795.282957           1949200.338012
> 300     906029.377539           1927881.231478
> 400     845696.690912           1911065.369776
> 500     812295.222497           1926237.255856
> 600     888030.104213           1903047.236273
> 700     866896.532490           1886537.202142
> 800     863407.341506           1883768.592610
> 900     871386.608563           1874638.012128
> 1000    887668.277133           1876402.391502
> 1500    860051.361395           1815103.564241
> 2000    890900.098657           1775435.271018
> 3000    874184.980039           1653953.817997
> 4000    845023.080703           1582582.316043
> 5000    817100.195728           1512260.802371
> 
> I think these are pretty nice results.

Attached as a graph as well.
Attachment

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Improving connection scalability: GetSnapshotData()
Next
From: Pavel Stehule
Date:
Subject: proposal - reglanguage type