Re: PostgreSQL server architecture

On 12/20/11 11:48 AM, James B. Byrne wrote:
> we are moving applications from
> dedicated boxes to kvm based CentOS-6.1 virtual machines
> on a single CentOS-6.1 host

Database servers often end up with suboptimal performance on virtual IO
hardware.   This is especially true if they are sharing storage channels
and devices with other virtual machines.   The 'big boys'
(<cough>IBM</cough>) often give a virtual machine running a database
server its own storage channel (typically, the HBA for use with a SAN)
to get around this.  Ditto, they give VM's their own network adapters

Now, if your databases aren't IO performance constrained, this very well
may not matter much.

--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast