From: Harald Armin Massa <haraldarminmassa@gmail.com>
To: Andreas Tille <tillea@rki.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL in virtual machine
Date: Mon, 12 Mar 2007 16:00:26 +0100
Message-ID: <7be3f35d0703120800kc3bbb99ub818fca7322ed161@mail.gmail.com> (raw)
In-Reply-To: <Pine.LNX.4.62.0703120919450.26538@wr-linux02>
References: <Pine.LNX.4.62.0703120919450.26538@wr-linux02>
Andreas,
I am responsible for some active PostgreSQL databases within virtual
machines and on "plain metal"; all using Windows.
There are spurious strange performance issues on those PostreSQL
databases within the virtual machines. I can not pin them down (yet),
and am not really able to blame them on vmware; but just want to
recommend to be very very carefull about PostgreSQL in vmware and
please communcate your findings.
> from a PostgreSQL 8.1 database in a virtual machine. I'm able to
> adjust the memory of this machine according to reasonable values
> and can choose between one or two (emulated) processors. The
> question is: How can I find an optimal relation between the
> virtual hardware parameters and PostgreSQL performance. I guess
You did not specify the OS in your VM. I can report my experiences
with W2k3 inside the VM:
contrary to usual recommendations, smaller shared_buffers yielded
better results.
Growing effective_cache_size yielded the best results for me.
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
fx 01212-5-13695179
-
Python: the only language with more web frameworks than keywords.
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: haraldarminmassa@gmail.com, tillea@rki.de
Subject: Re: PostgreSQL in virtual machine
In-Reply-To: <7be3f35d0703120800kc3bbb99ub818fca7322ed161@mail.gmail.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