From: Josh Berkus <josh@agliodbs.com>
To: pgsql-performance@postgresql.org
Subject: Re: Postgresql in a Virtual Machine
Date: Tue, 26 Nov 2013 09:31:23 -0800
Message-ID: <5294DAEB.8070204@agliodbs.com> (raw)
In-Reply-To: <WM!691506aeec394bb4583fe570a4c6496310bf8634ad94afd4d1ffb6397169814e31ea0f2452ac8871158b5268a8a89127!@asav-1.01.com>
References: <CAHghi5Cj_6KmwaUopF3y=vSjs3Q83VyXQy5DQhfLyP_Zt0yxbA@mail.gmail.com>
<WM!691506aeec394bb4583fe570a4c6496310bf8634ad94afd4d1ffb6397169814e31ea0f2452ac8871158b5268a8a89127!@asav-1.01.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On 11/25/2013 12:01 PM, Lee Nguyen wrote:
> Hi,
>
> Having attended a few PGCons, I've always heard the remark from a few
> presenters and attendees that Postgres shouldn't be run inside a VM. That
> bare metal is the only way to go.
This is pretty dated advice. Early VMs had horrible performance under
load, which is mostly where this thinking comes from. It's not true
anymore.
It *is* true that getting good performance in a virtualized environment
requires more tuning than bare metal, because you have to tune the VM
system as well.
> Here at work we were entertaining the idea of running our Postgres database
> on our VM farm alongside our application vm's. We are planning to run a
> few Postgres synchronous replication nodes.
Biggest pitfall here is IO performance configuration. I can't give you
specific advice without knowing the platform and the desired workload.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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-performance@postgresql.org
Cc: josh@agliodbs.com
Subject: Re: Postgresql in a Virtual Machine
In-Reply-To: <5294DAEB.8070204@agliodbs.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