| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Veerendra Pulapa <veerendra(dot)pulapa(at)ashnik(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Seeking Insights on Choosing the Right CPU and RAM for PostgreSQL Setup |
| Date: | 2024-07-18 15:48:48 |
| Message-ID: | 191aa8370a6d796c19473a42b7902718952252ec.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Muhammad Ikram | 2024-07-18 16:09:31 | Re: Seeking Insights on Choosing the Right CPU and RAM for PostgreSQL Setup |
| Previous Message | Paul Smith* | 2024-07-18 15:42:13 | Re: Seeking Insights on Choosing the Right CPU and RAM for PostgreSQL Setup |