> That said, it's inadvisable to run a database on a btree file system like ZFS or btrfs if you're keeping an eye on the write performance. Our writes are actu

> That said, it's inadvisable to run a database on a btree file system like ZFS or btrfs if you're keeping an eye on the write performance. Our writes are actually heavily CPU bound because of how we architected the system[0]. We recently made some changes that dramatically improved our write throughput, so AFAICT, we aren't going to need to focus much on write performance in the near future. [0] http://blog.heapanalytics.com/running-10-million-postgresql-indexes-in-production/ http://blog.heapanalytics.com/running-10-million-postgresql-...