From: Joshua D. Drake <jd@commandprompt.com>
To: David Bear <David.Bear@asu.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: running in a virtual environment
Date: Fri, 27 Aug 2010 08:56:14 -0700
Message-ID: <1282924574.17406.85.camel@jd-desktop.unknown.charter.com> (raw)
In-Reply-To: <AANLkTikQvW7NtvWmMwOWh72n77=RkOVLgxB0rUhK1=v=@mail.gmail.com>
References: <AANLkTikQvW7NtvWmMwOWh72n77=RkOVLgxB0rUhK1=v=@mail.gmail.com>
On Fri, 2010-08-27 at 08:21 -0700, David Bear wrote:
> I'm wondering what experience people have had running pg 8.x in a
> virtualized environment.
Just to be a pain, there is no 8.x. There is 8.0.x, or more specifically
the current version 8.4.x. The only reason I say this is we recently
spent way too many bytes on the inner tubes trying to have that
argument.
> Are there any best practices to follow that differen when running on
> a real metal?
You need to spec your IO higher. You take an IO hit by virtualizing and
it is significant. Considering provisioning at least 15% more IO than
you would on bare metal.
> Are there performance issue?
Just the minor IO one I mentioned.
> What virtual environment seems most friendly to pg ? Xen, VMWare,
> other?
For servers?
KVM, VMWare, Xen are all perfectly serviceable. Depends on your actual
business requirements.
> What about storage; is it best to keep the cluster in a filesystem
> that is part of the vm-image or on a mounted file system that exists
> external to the image? (in other words, a /dev/sdxx that is really
> some NAS type of device, or NFS? CIFS?)
This has to do with actual business requirements. I tend to prefer DAS
but a good SAN or NAS (iSCSI) configuration works well. I personally
would avoid anything that is just a network mount like NFS or CIFS.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jd@commandprompt.com, David.Bear@asu.edu
Subject: Re: running in a virtual environment
In-Reply-To: <1282924574.17406.85.camel@jd-desktop.unknown.charter.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox