Request a Demo
Home   >   mailing lists

Postgres Resource Sizing - Mailing list pgsql-admin

From Sam Stearns
Subject Postgres Resource Sizing
Date
Msg-id CAN6TVjn5JkPcbxbuzrQC71uZ6xOBYZvq9f4WJh-Ka_aeZCtZ6A@mail.gmail.com
Whole thread Raw
Responses Re: Postgres Resource Sizing
List pgsql-admin
Tree view
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

--

Samuel Stearns
Team Lead - Database
c: 971 762 6879 | o: 971 762 6879 | DAT.com


pgsql-admin by date:

Previous
From: Raj
Date:
Subject: Re: Wal_keep_size
Next
From: Holger Jakobs
Date:
Subject: Re: Postgres Resource Sizing