Re: Improving connection scalability: GetSnapshotData()

From: "Andres Freund" <andres(at)anarazel(dot)de>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Improving connection scalability: GetSnapshotData()
Date: 2020-09-07 20:45:48
Message-ID: 932e458c-116e-451d-b5b2-9dea2f72b13e@www.fastmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Mon, Sep 7, 2020, at 07:20, Konstantin Knizhnik wrote:
> >> And which pgbench database scale factor you have used?
> > 200
> >
> > Another thing you could try is to run 2-4 pgench instances in different
> > databases.
> I tried to reinitialize database with scale 200 but there was no
> significant improvement in performance.

If you're replying to the last bit I am quoting, I was talking about having four databases with separate pbench tables etc. To see how much of it is procarray contention, and how much it is contention of common buffers etc.

> Attachments:
> * pgbench.svg

What numactl was used for this one?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2020-09-07 20:49:20 Re: Auto-vectorization speeds up multiplication of large-precision numerics
Previous Message Tom Lane 2020-09-07 18:54:15 Re: Inaccurate comment, for family-1 polymorphic UNKNOWN type arguments