Re: Postgres Resource Sizing

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