The FreeBSD community improved basic UFS in its own way, into what it calls UFS2. This also expanded filesystem capacity to far beyond 2 TB, although there are still some user tools that may not support this yet; be sure to investigate that carefully before presuming you can host a large database on FreeBSD.
Instead, implement a journal (Linux) or logging (Solaris). FreeBSD's solution to filesystem integrity issues during a crash and resulting long filesystem recovery times is a technique called soft updates. This orders writes such that the only type of integrity issue after a crash is blocks marked as used but not actually claimed by any file. After an unclean shutdown, the filesystem can be brought up almost immediately. What's ...
