I run FreeBSD and Postgres on ZFS. It's been an entirely painless experience. No pitfalls to look out for from where I sit. Your use-case and results may differ.