public inbox for [email protected]
help / color / mirror / Atom feedFrom: Holger Jakobs <[email protected]>
To: [email protected]
Subject: Re: Postgres Resource Sizing
Date: Tue, 14 Oct 2025 22:38:24 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAN6TVjn5JkPcbxbuzrQC71uZ6xOBYZvq9f4WJh-Ka_aeZCtZ6A@mail.gmail.com>
References: <CAN6TVjn5JkPcbxbuzrQC71uZ6xOBYZvq9f4WJh-Ka_aeZCtZ6A@mail.gmail.com>
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
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: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Postgres Resource Sizing
In-Reply-To: <[email protected]>
* 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