Recommendations on how to combine SSD and HDD drives in bare metal PostgreSQL server
От | Onni Hakala |
---|---|
Тема | Recommendations on how to combine SSD and HDD drives in bare metal PostgreSQL server |
Дата | |
Msg-id | 89E7D559-F734-4739-9730-7EDDF787910D@flaky.build обсуждение исходный текст |
Ответы |
Re: Recommendations on how to combine SSD and HDD drives in bare metal PostgreSQL server
Re: Recommendations on how to combine SSD and HDD drives in bare metal PostgreSQL server Re: Recommendations on how to combine SSD and HDD drives in bare metal PostgreSQL server |
Список | 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 по дате отправления: