ZFS FreeBSD with 3SSD for PostgreSQL

cr4sh

Member

Reaction score: 3
Messages: 46

Hello. I have a server with only 3 SSD, I want to run only PostgreSQL on it. But I don't have idea what options of ZFS to use for best performance. Did anyone here such a setup, and can give me a hint?
Best regards.
 

ShelLuser

Son of Beastie

Reaction score: 2,151
Messages: 3,803

The first question coming to mind: why do you think regular performance won't be good enough? Generally speaking I'd say you shouldn't have to bother yourself too much with tweaking.
 

SirDice

Administrator
Staff member
Administrator
Moderator

Reaction score: 14,000
Messages: 40,724

You typically get the best performance with RAID0; striped set. But, there's no fault tolerance, if one disk breaks the whole set is gone. Second best, performance and fault-tolerance, RAID1+0; a striped mirror. Third best would be RAID5/RAIDZ.

But as ShelLuser noted, do you actually need the performance? Have you done any measurements?
 
OP
C

cr4sh

Member

Reaction score: 3
Messages: 46

Thank you for answers. I mean i have only SSD disk, and i read somewhere that SSD need to be specialy configured for ZFS and for good PostgreSQL performace. But now i think, i can make normal RAID5 with ZFS pool and all will be ok too ?
Best regards.
 
Top