Content-Type: multipart/alternative;
 boundary="------------xLcSRRL0EuCB8dvIzSv00xsE"
Message-ID: <07030892-d801-4d04-a506-24149186cd50@jakobs.com>
Date: Tue, 14 Oct 2025 22:38:24 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Postgres Resource Sizing
To: pgsql-admin@lists.postgresql.org
References: 
 <CAN6TVjn5JkPcbxbuzrQC71uZ6xOBYZvq9f4WJh-Ka_aeZCtZ6A@mail.gmail.com>
From: Holger Jakobs <holger@jakobs.com>
In-Reply-To: 
 <CAN6TVjn5JkPcbxbuzrQC71uZ6xOBYZvq9f4WJh-Ka_aeZCtZ6A@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/07030892-d801-4d04-a506-24149186cd50%40jakobs.com>
Precedence: bulk

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

Am 14.10.25 um 22:32 schrieb Sam Stearns:
> Howdy,
>
> We have an Oracle database that is processing 500 transactions per 
> second during peak hours.  We are migrating this to a Linux VM running 
> Postgres 17.6.  Is there anything out there that can give 
> recommendations on CPU / memory / shared_buffer sizing based on number 
> of transactions per second rate?  PGTune doesn't seem to have number 
> of transactions per second as an option.
>
> Thanks,
>
> Sam
>
Hi Sam,

The number of TPS you can achieve depends mainly on your (virtual) 
hardware, except that version 18 of PostgreSQL offers some improvements 
like asynchronous I/O.

PGTune tells you how to configure your system to get the best results, 
depending on your type of workload (web, oltp, dw, ...) using the 
properties of your hardware.

500 TPS doesn't seem much, so that should be easily achievable with 
almost any system, but of course it depends on the size of the 
transactions. Have you had any issues?

It's quite likely that 500 TPS can be performed without any tuning at 
all, although I wouldn't recommend that.

Kind Regards

Holger


> -- 
>
> Samuel Stearns
> Team Lead - Database
> c: 971 762 6879 |o: 971 762 6879 |DAT.com
>
> <https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link>
>
>
-- 

Holger Jakobs, Bergisch Gladbach, Germany

--------------xLcSRRL0EuCB8dvIzSv00xsE
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">Am 14.10.25 um 22:32 schrieb Sam
      Stearns:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAN6TVjn5JkPcbxbuzrQC71uZ6xOBYZvq9f4WJh-Ka_aeZCtZ6A@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div>Howdy,</div>
        <div><br>
        </div>
        <div>We have an Oracle database that is processing 500
          transactions per second during peak hours.  We are migrating
          this to a Linux VM running Postgres 17.6.  Is there anything
          out there that can give recommendations on CPU / memory /
          shared_buffer sizing based on number of transactions per
          second rate?  PGTune doesn't seem to have number of
          transactions per second as an option.</div>
        <div><br>
        </div>
        <div>Thanks,</div>
        <div><br>
        </div>
        <div>Sam</div>
        <div><br>
        </div>
      </div>
    </blockquote>
    <p>Hi Sam,</p>
    <p>The number of TPS you can achieve depends mainly on your
      (virtual) hardware, except that version 18 of PostgreSQL offers
      some improvements like asynchronous I/O.</p>
    <p>PGTune tells you how to configure your system to get the best
      results, depending on your type of workload (web, oltp, dw, ...)
      using the properties of your hardware. </p>
    <p>500 TPS doesn't seem much, so that should be easily achievable
      with almost any system, but of course it depends on the size of
      the transactions. Have you had any issues?</p>
    <p>It's quite likely that 500 TPS can be performed without any
      tuning at all, although I wouldn't recommend that.</p>
    <p>Kind Regards</p>
    <p>Holger</p>
    <p><br>
    </p>
    <p><br>
    </p>
    <blockquote type="cite"
cite="mid:CAN6TVjn5JkPcbxbuzrQC71uZ6xOBYZvq9f4WJh-Ka_aeZCtZ6A@mail.gmail.com">
      <div dir="ltr"><span class="gmail_signature_prefix">-- </span><br>
        <div dir="ltr" class="gmail_signature"
          data-smartmail="gmail_signature">
          <div dir="ltr"><span>
              <p dir="ltr"
style="line-height:1.38;margin-top:10pt;margin-bottom:10pt"><span
style="font-size:11pt;font-family:Inter,sans-serif;color:rgb(51,51,51);background-color:transparent;font-weight:700;vertical-align:baseline">Samuel
                  Stearns</span><span
style="font-size:11pt;font-family:Inter,sans-serif;color:rgb(51,51,51);background-color:transparent;font-weight:700;vertical-align:baseline"><br>
                </span><span
style="font-size:11pt;font-family:Inter,sans-serif;color:rgb(102,102,102);background-color:transparent;vertical-align:baseline">Team
                  Lead - Database</span><span
style="font-size:11pt;font-family:Inter,sans-serif;color:rgb(102,102,102);background-color:transparent;vertical-align:baseline"><br>
                </span><span
style="font-size:11pt;font-family:Inter,sans-serif;color:rgb(102,102,102);background-color:transparent;vertical-align:baseline">c:
                  971 762 6879 </span><span
style="font-size:11pt;font-family:Inter,sans-serif;color:rgb(147,149,152);background-color:transparent;vertical-align:baseline">|</span><span
style="font-size:11pt;font-family:Inter,sans-serif;color:rgb(102,102,102);background-color:transparent;vertical-align:baseline">
                  o: 971 762 6879 </span><span
style="font-size:11pt;font-family:Inter,sans-serif;color:rgb(147,149,152);background-color:transparent;vertical-align:baseline">|</span><span
style="font-size:11pt;font-family:Inter,sans-serif;color:rgb(102,102,102);background-color:transparent;vertical-align:baseline">
                  DAT.com</span></p>
              <p dir="ltr"
style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><a
href="https://www.dat.com/?utm_medium=email&amp;utm_source=DAT_email_signature_link"
                  target="_blank" moz-do-not-send="true"><span
style="font-size:11pt;font-family:Arial,sans-serif;color:rgb(17,85,204);background-color:transparent;vertical-align:baseline"><span
style="border:none;display:inline-block;overflow:hidden;width:126px;height:54px"><img
src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXchMTXZiU3P-OkN7UwPyrdxiCAOkHWIArmSrehhAl-cXaYxECakbMV5owUfMaMjAZZcbjttr8pEtSGrZjUSRNaxbLxumAthLgYlFE5iT2P2eOJu4jtqizp_fYM0Mq1DZyFUeHMhpGKjiGIzqD_ny_hPIzlt?key=z3dM0-Cr9WzKyLauPVBgWw"
                        width="126" height="54"
                        style="margin-left:0px;margin-top:0px"
                        moz-do-not-send="true"></span></span></a></p>
              <div><br>
              </div>
            </span></div>
        </div>
      </div>
    </blockquote>
    <div class="moz-signature">-- <br>
      <p>Holger Jakobs, Bergisch Gladbach, Germany</p>
    </div>
  </body>
</html>

--------------xLcSRRL0EuCB8dvIzSv00xsE--