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?
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?
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 ?