Sender: Onni Hakala <onni@keksi.io>
From: Onni Hakala <onni@fyff.ee>
Content-Type: text/plain;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3818.100.11.1.3\))
Subject: Recommendations on how to combine SSD and HDD drives in bare metal
 PostgreSQL server
Message-Id: <89E7D559-F734-4739-9730-7EDDF787910D@flaky.build>
Date: Wed, 16 Oct 2024 17:06:24 +0300
To: pgsql-novice@lists.postgresql.org
Archived-At: 
 <https://www.postgresql.org/message-id/89E7D559-F734-4739-9730-7EDDF787910D%40flaky.build>
Precedence: bulk

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=E2=80=99m 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