Re: PostgreSQL server architecture - Mailing list pgsql-general

From John R Pierce
Subject Re: PostgreSQL server architecture
Date
Msg-id 4EF125F8.2050405@hogranch.com
Whole thread Raw
In response to PostgreSQL server architecture  ("James B. Byrne" <byrnejb@harte-lyne.ca>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Misa Simic
Date:
Subject: Re: design help for performance
Next
From: "David Johnston"
Date:
Subject: Re: design help for performance