Content-Type: multipart/alternative;
 boundary="------------cu3SnpV2HnTPLBAB66baFS0R"
Message-ID: <8b0f6c9b-d9c9-4971-b9ac-e1d0d69f3d98@gmail.com>
Date: Mon, 4 May 2026 23:03:41 +0500
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Improving PostgreSQL insert performance
To: Frits Jalvingh <jal@etc.to>,
 Vladimir Sitnikov <sitnikov.vladimir@gmail.com>,
 "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
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>
Content-Language: en-US
From: =?UTF-8?B?0KDRg9GB0LjQvdC+0LIg0KHQtdC80LXQvQ==?= <mrpinkolik@gmail.com>
Autocrypt: addr=mrpinkolik@gmail.com; keydata=
 xsFNBGDdbP4BEACxHgtdqUgOwTW811f80STub1LWcpVtvfkq45y9UTCf4JkjpnplzRCsHagY
 8rWzfubqGoYhryMBmtEBVQsqqxf2K4YJbra2rPbWcKl11y3GciVHWpqCXBlhREwSfannN16i
 VOPi4x+yGVo0FNoMie0ZSNu2ld8dbl9FZOsNFcqHzuokKhyw30VROaek6ybjtJ689RypU/EL
 bQ4j1ONt+rJgZfYTT43A8ZG+16JuUzcofgzY03cxFqHov0sQKEFjr482orAtSrUNmUFlXCbm
 68xaCuZJdO22KHro6/icWwJOYlBxOJNyrk8f7Ks2OY0R2qiM3/41R5McObTOeU51iqx+ezK9
 X0rMlZqgeJf2aEHrqQe7j3zIC8tqGlWwTT1k+eu2vd/uvRwkN2HFHaRvSB/Z5nKLW2Uq0G+f
 Ub6asJW4tCUNVyjQa52rSAyudiMxNlbunJ/RTzqRl3vacwariQkjSA35299gYzaM5QqxblPB
 fkLxaH7GXPvR2e8JDLr6dJmgXhsGcRgFbyfUObOm6T1Ls6ScRV+xQ6rCUSolGszKW5pIqTvv
 k1pGQ2tR2CaVceZlEwQBmXNmuhS17dahtytnxC6X3YFNcGuR3DulxuVNLxEXSDkZ6prVnpS8
 NqapVL+rwLtolYyGMd+r4C3YdcmnVzV56dGy/aeEl8shybXRdQARAQABzSRTaW1vbiBSdXNp
 bm92IDxtcnBpbmtvbGlrQGdtYWlsLmNvbT7CwY4EEwEIADgCGwMFCwkIBwIGFQoJCAsCBBYC
 AwECHgECF4AWIQRSC4v2d3/2ZLWzVSqgvJe+hzUr9QUCZJ52rQAKCRCgvJe+hzUr9YXaD/4p
 iEEVk0t6ab8TfdSojSIRB2oSTDab2SVXjsmTL+rU3AJwJz+X8wxZmyNc/I5gS8wkrzWHQGhf
 X5I2Ghdcf17OrQVt+Ui7H3mFA0xB+F3io/qluGiU7Rtun7C+HLWaSWL98Y+omwh41IYtxiQv
 OwWvFJVNA+IsYjvnvokWb9SYaNHtVCbzp2vi3nu5fM14kwTAyq9Xd+kN67SQm4qXCpnwtJ7c
 Bl8gKnTDubsDn8TXoIKunJZBxHWCvtOTOnur7zS/xqwxZAubzauYoD13al4/O+V/lOhgRsbs
 sHA2Iosnme1yZUSLYr0IBQhabq1Cri+LuOR1FPAlpXqPPUbdMo9FxmFf3R2K18P/rlOksDSI
 U2Uf5D2gddj3MNs4mb1Vb9efUsy60/O7er8BXl//lIojVQOtj2aULvqvmyCG44gu8/MXN1mp
 mo7zqdKYCq1miRGGZgxNa4kyoANsQVeiv9xK14k/ogXn/fwa86PUBcY8czAosi8TFxERaZhU
 1YTKWC88dWNvsnrDRJJq6wc/u3Z/zdRGBG79el00tcjIP7zT+2LaY6OkxRwMQS1x4oPmGLXQ
 VFr2pF8gWPKvUUIjqIlpHG1c1DJmOE0qkTqm6aTuBdBTbbFEWISoHo9F8MIlvfThQiR5ULEk
 5FsCGQNC1L9AXJN19RAtOTC0Kftwg/ZN4c7BTQRg3Wz+ARAA04jDNh5J2WbvJnpzfiGuCAT4
 H9pumaNFakdI5z8MEk/5AiIXuR8Tc+QUy7mt689vwzKerbgnwVnTE8P86zL/zxN9DEhewc0U
 F4TMgN6GQS7SXAcMVEQp6byWx+J6uHHlaPZMjAm+U7NHsNeu19hmPK2GgEbE0tR8lXqQLgio
 +N0sRDtDnmNXNtvdm1sVW2JyTRLqJ/mBS6cf7x3dYCr6uD/NHmCuF6uCyV7sTg5gHULaVbYc
 FqXs5eQMAvIA2/yjpQsL8+JLKP92GM9oLYmFdJhPs6w7WL8TXgTUbzsBPWtxQCDhE2EXhnw7
 KtBMSmjCuRSZpIzo838uBCSEzizNl5GllFL/Hf020oKAk9Kt18Ah7616OnJQNKg0AkZvgCyu
 8bm5K/KBZZXKB+V3EWxol39VcXvH78UQ/huyDZ0YNCrpqKWkuSdTVvSTGPsYZS4X+RDf+Vyc
 JIjZ1xabGR+ajDVL5EFqkBOtTbhwyBCvutNaI1hXNYaGdi6/NobOQjrmgfhQsoyfAMCTab/B
 loq7CkFFGs09xlWdOSxpyxdltiYJDwiMoQXrUEYMQ0bW4b1OI0EU8rLA4gNpTRHYJp6Z6hl8
 kgBO8z+l/PtBCbGUO5G6zbFTMj1RMOgMcY0OVIJanySTwKprDc2cVRjML0IZlLp5/Dtvry6F
 pBxTQRfVeKkAEQEAAcLBdgQYAQgAIAIbDBYhBFILi/Z3f/ZktbNVKqC8l76HNSv1BQJknncP
 AAoJEKC8l76HNSv1XrEP/1+0MJVUafU6ZsQHJ232lKhZSWOsD7wR8hy3jz4j+1nBtIMz2Djr
 gU2L/9wOv/O3cKRYw+Rqg5LC3FuVTRRvSw7RedkBbfJdvTA3avyqrpjS4HEOugyPJ+T9jcuq
 2RGfHPuy177z2hop2W38TD4wRmwlxALJ4a8vpzeAWV6NTDcRVU1cnKOAm0IqUNxskLyMAN+v
 vVda5RzlyHGwr63DYJEEteOtBmWK4kh0xUNtDZRtZ6Fe6mMeJOk3YGSA+5orLoM7zF79fp6g
 02WDQppXF+Ujz+HYnvQ9VTJeuzd9AuuQiAF6tr0penhyYRQXlEsOKd9hlTpxW8pyFuhpNbWV
 2GKUh2vt276WiYhEKMwnsygSLipYdLuzskdxYI9rnGq0xLOVCqxDwq0Icq8S5HC2Xams3hDB
 aMmw/IHCYgY6Wtley9GD5EDOL9oHqaLKav1qgWXcugJ27D42B2dypWSchcqhwXKI1G/m0Y72
 GtcQxGB7byaQgRJgFvIfkG3kB0eBrOdj2lbEDem7/LxEJHka/6wD3TpWMDO8mvASLJHiOumO
 yAdoFVXSWtcJLO7l4rPEt+uOn21+XXhBgI9aqodKMwKb9aRDtw6z8nj+/KB7MJMYZB6aKWie
 1QATY2m4Us8KGNc1LozBEw8VcAezEZFlP+iSnrX6HtdXNxXuVqmOjLzY
In-Reply-To: <CAKhTGFVZh81W8hZAdV5KbEsTrKwebBG+1MG1x5b7Gr=ujyn7mA@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/8b0f6c9b-d9c9-4971-b9ac-e1d0d69f3d98%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------cu3SnpV2HnTPLBAB66baFS0R
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

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
--------------cu3SnpV2HnTPLBAB66baFS0R
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>Hello Frits,<br>
      <br>
      Would you mind sharing an updated link to your benchmark and
      source code?</p>
    <p><br>
    </p>
    <p>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.<br>
      <br>
      Best regards,<br>
      Simon</p>
    <div class="moz-cite-prefix">On 6/10/17 16:12, Frits Jalvingh wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAKhTGFVZh81W8hZAdV5KbEsTrKwebBG+1MG1x5b7Gr=ujyn7mA@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr"><br>
        <div class="gmail_quote">
          <div dir="ltr">On Sat, Jun 10, 2017 at 12:08 AM Vladimir
            Sitnikov &lt;<a href="mailto:sitnikov.vladimir@gmail.com"
              moz-do-not-send="true" class="moz-txt-link-freetext">sitnikov.vladimir@gmail.com</a>&gt;
            wrote:<br>
          </div>
          <blockquote class="gmail_quote"
style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div dir="ltr">
              <div>Would you mind sharing the source code of your
                benchmark?</div>
            </div>
          </blockquote>
          <div><br>
          </div>
          <div>The source code for the several tests, plus the numbers
            collected so far, can be found at:</div>
          <div><br>
          </div>
          <div><a
href="https://etc.to/confluence/display/~admjal/PostgreSQL+performance+tests"
              moz-do-not-send="true" class="moz-txt-link-freetext">https://etc.to/confluence/display/~admjal/PostgreSQL+performance+tests</a><br>
          </div>
          <div><br>
          </div>
          <div>Regards,</div>
          <div><br>
          </div>
          <div>Frits</div>
        </div>
      </div>
    </blockquote>
  </body>
</html>

--------------cu3SnpV2HnTPLBAB66baFS0R--