I'm just preparing a VM machine (running onver Proxmox) to run a postgresql 9.6 over a Ubuntu 16.04 LTS. This postgres would be used to handle Jira/FisheEye/Confluence databases for a small company. Usually we are a few user at same time, so we not need to tune it for extreme performance/scalability.
Well, the case is that we have using BTRFS on the servers as help us to handle the problem of adding extra space to a VM when is necessary, plus we enable lzo compression. Also, we use btrok to handle backups of BTRFS subvolumes to another machine.
I have doubts if could be a good idea use BTRFS to handle the postgresql DB files as we would be very helpful on the case that we need to expand the virtual hard disk space, but I read about postgresql bad performance over BTRFS (on special if the datacow is not disabled.
Anyone have experience with this situation ?