Recommendations on how to combine SSD and HDD drives in bare metal PostgreSQL server - Mailing list pgsql-novice

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
accessand 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
toadd 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




pgsql-novice by date:

Previous
From: Muhammad Ikram
Date:
Subject: Re: Oracle -> Pg migration
Next
From: Bzzzz
Date:
Subject: Re: Recommendations on how to combine SSD and HDD drives in bare metal PostgreSQL server