Re: Seeking Insights on Choosing the Right CPU and RAM for PostgreSQL Setup

Hi Veerendra,

I will suggest

SSD storage 2 to 3 times bigger than your database to account for growth.
Vacuum etc specially if Tables are very big or expected to grow fast. For
high TPS 32 cores or more processors.
Memory 128 Gig or more. More memory is better to keep active dataset in
memory to avoid excessive I/O.

Regards,
Muhammad Ikram

On Thu, Jul 18, 2024 at 8:52 PM Veerendra Pulapa <
veerendra(dot)pulapa(at)ashnik(dot)com> wrote:

> Hi Muhammad,
>
> Yes, the previous email was generic without specific details. However, I
> would appreciate guidance on sizing based on the following specifics:
>
>
> 1. Database size: Approximately 5TB.
>
> 2. Current TPS (Transactions Per Second): 1000-1500 TPS.
>
> 3. Read-write ratio: 60-40%.
>
> 4. Configuration: It’s a three-node setup.
>
> 5. Concurrent users: Typically between 300-350.
>
>
> Br,
> Veerendra Pulapa | Technical Consultant
> M: +91-9949349894 | www.ashnik.com
>
>
> <https://www.linkedin.com/company/ashnik-pte-ltd/>
> <https://www.facebook.com/AshnikBiz>
> <https://www.youtube.com/user/ashnikbiz>
> <https://www.instagram.com/ashnikbiz/> <https://twitter.com/Ashnikbiz>
>
>
> On Thu, Jul 18, 2024 at 9:10 PM Muhammad Ikram <mmikram(at)gmail(dot)com> wrote:
>
>> Hi Veerendra,
>>
>> It depends on your database size, kind of queries, concurrent users etc.
>> BTW, your question is too generic.
>>
>> Regards,
>> Muhammad Ikram
>>
>>
>> On Thu, Jul 18, 2024 at 8:34 PM Veerendra Pulapa <
>> veerendra(dot)pulapa(at)ashnik(dot)com> wrote:
>>
>>> Dear PostgreSQL Community,
>>>
>>>
>>> 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.
>>>
>>>
>>> Thank you!
>>>
>>>
>>> Br,
>>> Veerendra Pulapa | Technical Consultant
>>> M: +91-9949349894 | www.ashnik.com
>>>
>>>
>>> <https://www.linkedin.com/company/ashnik-pte-ltd/>
>>> <https://www.facebook.com/AshnikBiz>
>>> <https://www.youtube.com/user/ashnikbiz>
>>> <https://www.instagram.com/ashnikbiz/>
>>> <https://twitter.com/Ashnikbiz>
>>>
>>>
>>> *______________________________________________________________________________________This
>>> email may contain confidential, privileged or copyright material and is
>>> solely for the use of the intended recipient(s). If you are not the
>>> rightful recipient of this email, please delete this email immediately and
>>> inform the recipient. *
>>>
>>>
>>
>> --
>> Muhammad Ikram
>>
>>
>
> *______________________________________________________________________________________This
> email may contain confidential, privileged or copyright material and is
> solely for the use of the intended recipient(s). If you are not the
> rightful recipient of this email, please delete this email immediately and
> inform the recipient. *
>
>

--
Muhammad Ikram