I've not observed other databases locking up on ZFS, Postgres and MySQL both function just fine, without needing to modify any settings.