Re: PostgreSQL in virtual machine

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.