[GENERAL] PostgreSQL server architecture

2011-12-20 Thread James B. Byrne
We run a small in-house data centre for our various operations. Currently, we are moving applications from dedicated boxes to kvm based CentOS-6.1 virtual machines on a single CentOS-6.1 host. At issue is the question on how to handle the PostgreSQL instances that we currently have running on

Re: [GENERAL] PostgreSQL server architecture

2011-12-20 Thread Bill Moran
In response to James B. Byrne byrn...@harte-lyne.ca: We run a small in-house data centre for our various operations. Currently, we are moving applications from dedicated boxes to kvm based CentOS-6.1 virtual machines on a single CentOS-6.1 host. At issue is the question on how to handle the

Re: [GENERAL] PostgreSQL server architecture

2011-12-20 Thread Craig Ringer
On 21/12/2011 4:08 AM, Bill Moran wrote: In response to James B. Byrnebyrn...@harte-lyne.ca: We run a small in-house data centre for our various operations. Currently, we are moving applications from dedicated boxes to kvm based CentOS-6.1 virtual machines on a single CentOS-6.1 host. At

Re: [GENERAL] PostgreSQL server architecture

2011-12-20 Thread John R Pierce
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