pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedFrom: Paul Smith* <paul@pscs.co.uk>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Seeking Insights on Choosing the Right CPU and RAM for PostgreSQL Setup
Date: Thu, 18 Jul 2024 16:42:13 +0100
Message-ID: <e54646cf-6320-4d76-a37e-650f5021208d@pscs.co.uk> (raw)
In-Reply-To: <CAND8iOvUXp+UpVcenHWxz=MywUZqEDwM7h-TrjAk6A1YoHsD=w@mail.gmail.com>
References: <CAND8iOvUXp+UpVcenHWxz=MywUZqEDwM7h-TrjAk6A1YoHsD=w@mail.gmail.com>
On 18/07/2024 16:33, Veerendra Pulapa 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:
>
Without knowing the details of the workload and data etc, it's pretty
much impossible to say.
A 1 core CPU at 1.5GHz with 2GB of RAM will happily run PostgreSQL, but
may not be able to run it at your desired speed with your workload.
Conversely 256 cores at 3GHz with 1TB of RAM will also happily run
PostgreSQL, but may be overkill.
Also, from experience, disk system is at least as important as CPU/RAM
(until you get to the point where the RAM will hold the whole database
in cache). Running a fast CPU with lots of RAM won't be any use if
you're running it on 5400 RPM SATA drives in a RAID 5 array....
Paul
view thread (7+ messages) latest in thread
Message-ID: <e54646cf-6320-4d76-a37e-650f5021208d@pscs.co.uk>
Permalink: ../e54646cf-6320-4d76-a37e-650f5021208d@pscs.co.uk/
Also on: postgresql.org/message-id/e54646cf-6320-4d76-a37e-650f5021208d@pscs.co.uk
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: paul@pscs.co.uk, pgsql-admin@lists.postgresql.org
Subject: Re: Seeking Insights on Choosing the Right CPU and RAM for PostgreSQL Setup
In-Reply-To: <e54646cf-6320-4d76-a37e-650f5021208d@pscs.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox