Re: Seeking Insights on Choosing the Right CPU and RAM for PostgreSQL Setup - Mailing list pgsql-admin
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.
On Thu, Jul 18, 2024 at 9:10 PM Muhammad Ikram <mmikram@gmail.com> wrote:Hi Veerendra,It depends on your database size, kind of queries, concurrent users etc. BTW, your question is too generic.Regards,Muhammad IkramOn Thu, Jul 18, 2024 at 8:34 PM Veerendra Pulapa <veerendra.pulapa@ashnik.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:
RAM:
- Optimal number of cores?
- Impact of clock speed?
- Preferred CPU architectures?
- 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!
______________________________________________________________________________________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.
--
pgsql-admin by date: