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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: Seeking Insights on Choosing the Right CPU and RAM for PostgreSQL Setup
From: Ron Johnson <ronljohnsonjr@xxxxxxxxx>
Date: Fri, 19 Jul 2024 08:17:08 -0400
In-reply-to: <CAGeimVrHbOL-nBMgL8-0o7dgVtCwCnXKZT3a2PzV9b=EUDi+Lw@mail.gmail.com>
References: <CAND8iOvUXp+UpVcenHWxz=MywUZqEDwM7h-TrjAk6A1YoHsD=w@mail.gmail.com> <CAGeimVqzCq-F_=A09yhCDDHxXBfWY1dVstO+uM04pEqDaexNXQ@mail.gmail.com> <CAND8iOsUh6+CDi4Qch0Qz9R8FRtJfBa2hha_nfDarE=fUJisgg@mail.gmail.com> <CAGeimVrHbOL-nBMgL8-0o7dgVtCwCnXKZT3a2PzV9b=EUDi+Lw@mail.gmail.com>

That's a heck of a lot of waste on a multi-TB DB in a VM+SAN environment, where lots of other systems want their resources too (even with over-provisioning and data-duplication).

On Thu, Jul 18, 2024 at 12:10 PM Muhammad Ikram <mmikram@xxxxxxxxx> wrote:

Hi Veerendra,

I will suggest

SSD storage 2 to 3 times bigger than your database to account for growth.

References:
- Seeking Insights on Choosing the Right CPU and RAM for PostgreSQL Setup
  - From: Veerendra Pulapa
- Re: Seeking Insights on Choosing the Right CPU and RAM for PostgreSQL Setup
  - From: Muhammad Ikram
- Re: Seeking Insights on Choosing the Right CPU and RAM for PostgreSQL Setup
  - From: Muhammad Ikram

Prev by Date: Enhance pg_dump multi-threaded streaming (WAS: Re: filesystem full during vacuum - space recovery issues)
Next by Date: Re: Enhance pg_dump multi-threaded streaming (WAS: Re: filesystem full during vacuum - space recovery issues)
Previous by thread: Re: Seeking Insights on Choosing the Right CPU and RAM for PostgreSQL Setup
Next by thread: Re: Seeking Insights on Choosing the Right CPU and RAM for PostgreSQL Setup
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Home] [Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Forum]