On Sun, Jan 29, 2012 at 7:48 PM, Ron Arts <ron.arts@gmail.com> wrote:
> Hi list,
>
> I am running PostgreSQL 8.1 (CentOS 5.7) on a VM on a single XCP (Xenserver) host.
> This is a HP server with 8GB, Dual Quad Core, and 2 SATA in RAID-1.
>
> The problem is: it's running very slow compared to running it on bare metal, and
> the VM is starving for I/O bandwidht, so other processes (slow to a crawl.
> This does not happen on bare metal.
My experience with xen and postgres, which we use for testing upgrades
before doing them on production servers, never in production per-se,
is that I/O is very costly on CPU cycles because of the necessary talk
between domU and dom0.
It's is worthwhile to pin at least one core for exclusive use of the
dom0, or at least only let low-load VMs use that core. That frees up
cycles on the dom0, which is the one handling all I/O.
You'll still have lousy I/O. But it will suck a little less.