ZFS FreeBSD + ZFS + PostgreSQL, need suggestions.

[fender0107401]

Requirement: Install a FreeBSD system with zfs, and then run PostgreSQL.

The system has two same hard disks, so I want a zfs mirror.

In order to improve the PostgreSQL performance, what should I do this with this:

 

[Eric A. Borisch]

Change the pool type to mirror, then have a look at this: https://people.freebsd.org/~seanc/postgresql/scale15x-2017-postgresql_zfs_best_practices.pdf

 

[fender0107401]

Change the pool type to mirror, then have a look at this: https://people.freebsd.org/~seanc/postgresql/scale15x-2017-postgresql_zfs_best_practices.pdf

Thanks. I will check it.

 

[azathoth]

Isn't UFS without softupdates the pro way? under postgresql...and then extents or something aligned like was it 8k or something.....