public inbox for pgsql-performance@postgresql.org
help / color / mirror / Atom feedFrom: Русинов Семен <mrpinkolik@gmail.com>
To: Frits Jalvingh <jal@etc.to>
To: Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Improving PostgreSQL insert performance
Date: Mon, 4 May 2026 23:03:41 +0500
Message-ID: <8b0f6c9b-d9c9-4971-b9ac-e1d0d69f3d98@gmail.com> (raw)
In-Reply-To: <CAKhTGFVZh81W8hZAdV5KbEsTrKwebBG+1MG1x5b7Gr=ujyn7mA@mail.gmail.com>
References: <20170609132857.GC26506@aart.rice.edu>
<CAKhTGFVTvFxsfngDNgQV-ciWYFn6aXROwGj6s4Gqkqa0bTusJw@mail.gmail.com>
<CAOR=d=1CYLvtesjcCmC95rWZSzJ02pYZyfJ8SA9jfx-CCekx3A@mail.gmail.com>
<CAKhTGFXiU_t_EiB37q-H897pFqQY9a=hDAuAZV7T3dLMTsvSiw@mail.gmail.com>
<CA+wvBw0P92PF95hewt5OWc_9oQByJTwEynV=Lv2MdguB2o-kFQ@mail.gmail.com>
<CAKhTGFVBu3Zrsp6oRSpTEgWvnie4Wbx++P6=WTfZOWptLOKj+Q@mail.gmail.com>
<4CC4AADC-59DB-4B3D-8A07-4A110E97D5A5@unigroup.com>
<CAKhTGFW2xJ9cmRSge3rMpVzBK73_oWSPWQrqF-TYeCtuTKGXjA@mail.gmail.com>
<9840E469-1D75-4BF2-AA4D-CE8FB21E0FCC@unigroup.com>
<CAKhTGFVoxFfh+5+ZkEb3s_ynb2HnTRzaOBPvK1Tpy0+7GfM2BQ@mail.gmail.com>
<20170609153333.GF26506@aart.rice.edu>
<CAKhTGFUi7DsN7Y4ECLA5o0CepwkWjPh-pdOhfFbE36h2dL+e9g@mail.gmail.com>
<CAB=Je-Hh4ieW2Sv0HcAbaAnrf6xV_dK+OQ536ELNtY6619KF0A@mail.gmail.com>
<CAKhTGFVZh81W8hZAdV5KbEsTrKwebBG+1MG1x5b7Gr=ujyn7mA@mail.gmail.com>
Hello Frits,
Would you mind sharing an updated link to your benchmark and source code?
I am also currently tuning postgresql single insert performance for the
outbox pattern. And I'm stuck at 35k inserts per second. However, it
doesn't look like I have reached hardware limit. CPU usage is moderate,
around 20%, RAM is also 20% free. I've tried all sorts of optimizations
but still can't get pass through this RPS, and neither can I understand
what is limiting postgres from inserting at a faster pace.
Best regards,
Simon
On 6/10/17 16:12, Frits Jalvingh wrote:
>
> On Sat, Jun 10, 2017 at 12:08 AM Vladimir Sitnikov
> <sitnikov.vladimir@gmail.com> wrote:
>
> Would you mind sharing the source code of your benchmark?
>
>
> The source code for the several tests, plus the numbers collected so
> far, can be found at:
>
> https://etc.to/confluence/display/~admjal/PostgreSQL+performance+tests
>
> Regards,
>
> Frits
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mrpinkolik@gmail.com, jal@etc.to, sitnikov.vladimir@gmail.com
Subject: Re: Improving PostgreSQL insert performance
In-Reply-To: <8b0f6c9b-d9c9-4971-b9ac-e1d0d69f3d98@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox