From: Andrew Dunstan <andrew@dunslane.net>
To: Heikki Linnakangas <hlinnakangas@vmware.com>
Cc: Lee Nguyen <leemobile@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgresql in a Virtual Machine
Date: Mon, 25 Nov 2013 15:28:36 -0500
Message-ID: <5293B2F4.10102@dunslane.net> (raw)
In-Reply-To: <5293B0B9.1060200@vmware.com>
References: <CAHghi5Cj_6KmwaUopF3y=vSjs3Q83VyXQy5DQhfLyP_Zt0yxbA@mail.gmail.com>
<5293B0B9.1060200@vmware.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On 11/25/2013 03:19 PM, Heikki Linnakangas wrote:
> On 25.11.2013 22:01, 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.
>>
>> 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.
>>
>> Why shouldn't we run Postgres in a VM? What are the downsides? Does
>> anyone
>> have any metrics or benchmarks with the latest Postgres?
>
> I've also heard people say that they've seen PostgreSQL to perform
> worse in a VM. In the performance testing that we've done in VMware,
> though, we haven't seen any big impact. So I guess the answer is that
> it depends on the specific configuration of CPU, memory, disks and the
> software. Synchronous replication is likely going to be the biggest
> bottleneck by far, unless it's mostly read-only. I don't know if
> virtualization will have a measurable impact on network latency, which
> is what matters for synchronous replication.
>
> So, I'd suggest that you try it yourself, and see how it performs. And
> please report back to the list, I'd also love to see some numbers!
>
>
Yeah, and there are large numbers of public and/or private cloud-based
offerings out there (from Amazon RDS, Heroku, EnterpriseDB and VMware
among others.) Pretty much all of these are VM based, and can be
suitable for many workloads.
Maybe the advice is a bit out of date.
cheers
andrew
--
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: andrew@dunslane.net, hlinnakangas@vmware.com, leemobile@gmail.com
Subject: Re: Postgresql in a Virtual Machine
In-Reply-To: <5293B2F4.10102@dunslane.net>
* 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