| 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: | Postg범퍼카 토토SQL |
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?
| 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 |