Postgres Pro
Downloads
Home   >   mailing lists

Re: Seeking Insights on Choosing the Right CPU and RAM for PostgreSQL Setup - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Seeking Insights on Choosing the Right CPU and RAM for PostgreSQL Setup
Date
Msg-id CANzqJaBMxeTPvw7nwdRSZJtU-dKkgBM8rPUUqX1W+dEGNMO1sw@mail.gmail.com
Whole thread Raw
In response to Re: Seeking Insights on Choosing the Right CPU and RAM for PostgreSQL Setup  (Muhammad Ikram <mmikram@gmail.com>)
List pgsql-admin
Tree view
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@gmail.com> wrote:
Hi Veerendra,

I will suggest

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

pgsql-admin by date:

Previous
From: Domen Šetar
Date:
Subject: RE: wal seams to be corrupted
Next
From: Ron Johnson
Date:
Subject: Re: Enhance pg_dump multi-threaded streaming (WAS: Re: filesystem full during vacuum - space recovery issues)