agora inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedFrom: Laurenz Albe <laurenz.albe@cybertec.at>
To: Veerendra Pulapa <veerendra.pulapa@ashnik.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Seeking Insights on Choosing the Right CPU and RAM for PostgreSQL Setup
Date: Thu, 18 Jul 2024 17:48:48 +0200
Message-ID: <191aa8370a6d796c19473a42b7902718952252ec.camel@cybertec.at> (raw)
In-Reply-To: <CAND8iOvUXp+UpVcenHWxz=MywUZqEDwM7h-TrjAk6A1YoHsD=w@mail.gmail.com>
References: <CAND8iOvUXp+UpVcenHWxz=MywUZqEDwM7h-TrjAk6A1YoHsD=w@mail.gmail.com>
On Thu, 2024-07-18 at 21:03 +0530, Veerendra Pulapa wrote:
> I hope you’re all doing well. We’re currently evaluating hardware options for our
> PostgreSQL setup, specifically focusing on CPU and RAM. We’d love to hear your insights
> on the following:
>
> CPU:
> * Optimal number of cores?
> * Impact of clock speed?
> * Preferred CPU architectures?
> RAM:
> * Recommended amount?
> * Importance of memory bandwidth?
> * Buffer cache configuration tips?
>
> Any advice or experiences you can share would be greatly appreciated. Your input will
> help us make informed decisions and optimize our setup.
How big is the database going to be?
How many transactions per second do you expect?
How many concurrent statements will you have to handle?
What kind of workload is it going to be? OLTP? Analytical? Mixed?
Yours,
Laurenz Albe
view thread (7+ messages) latest in thread
Message-ID: <191aa8370a6d796c19473a42b7902718952252ec.camel@cybertec.at>
Permalink: ../191aa8370a6d796c19473a42b7902718952252ec.camel@cybertec.at/
Also on: postgresql.org/message-id/191aa8370a6d796c19473a42b7902718952252ec.camel@cybertec.at
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: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, veerendra.pulapa@ashnik.com, pgsql-admin@lists.postgresql.org
Subject: Re: Seeking Insights on Choosing the Right CPU and RAM for PostgreSQL Setup
In-Reply-To: <191aa8370a6d796c19473a42b7902718952252ec.camel@cybertec.at>
* 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