postgres

  1. H

    From a VM OS point of view: It's an "standard" FS (like ext4) still COW when residing in a ZVOL on top of a proxmox host with ZFS?

    I thought that it was true, but after reading some answers in this thread now I have doubts. The real reason why I want to know it's because of the full_page_writes parameter in postgresql DB. Setting it to off improves the performance greatly (almost x2) but for non COW FS keeps the DB in a...
  2. A

    Geo split cluster?

    I have several servers rent in two datacenters. This is done to overcome DC outages (which is rare case but still happens), and so we'd like to have data from one DC to be copied to second one so we can use it to run reserved VMs with that data. The data itself is Postgresql databases and...