Re: PostgreSQL server architecture

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL server architecture
Date: 2011-12-21 00:19:04
Message-ID: 4EF125F8.2050405@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2011-12-21 00:27:45 Re: design help for performance
Previous Message Misa Simic 2011-12-21 00:12:40 Re: design help for performance