Re: Postgres Resource Sizing

Thanks for the information, Holger! This helps. We have our VM's tuned
with help from PGTune. I'll talk to our Linux team some more about the TPS.

Sam

On Tue, Oct 14, 2025 at 1:41 PM Holger Jakobs <holger(at)jakobs(dot)com> wrote:

> 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
> ZjQcmQRYFpfptBannerStart
> This Message Is From an External Sender
> This message came from outside your organization.
>
> ZjQcmQRYFpfptBannerEnd
> 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
>

--

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>