public inbox for [email protected]  

help / color / mirror / Atom feed

From: Onni Hakala <[email protected]>
To: [email protected]
Subject: Recommendations on how to combine SSD and HDD drives in bare metal PostgreSQL server
Date: Wed, 16 Oct 2024 17:06:24 +0300
Message-ID: <[email protected]> (raw)

Hey,

I have a large dataset of > 100TB which would be very expensive to store solely into SSD drives.

I have access to a server which has 2x 3.84TB NVME SSD disks and large array of HDD drives 8 x 22TB.

Most of the data that I have in my dataset is very rarely accessed and is stored only for archival purposes.

What would be the de-facto way to use both SSD and HDD together in a way use where commonly used data would be fast to access and old data would eventually only be stored in compressed format in the HDDs?

I was initially looking into building zpool using zfs with raidz3 and zstd compression for my HDDs but I’m unsure how to add the SSDs into this equation and I thought that this is probably a common scenario and wanted to ask opinions from here.

Thanks in advance,
Onni Hakala

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: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Recommendations on how to combine SSD and HDD drives in bare metal PostgreSQL server
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox