[PERFORM] PostgreSQL in virtual machine

[Andreas Tille]

Hi,

I'm running a Zope web application that obtains most of its data
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
it makes no sense to blindly increase virtual memory without
adjusting PostgreSQL configuration.  Are there any experiences
about reasonable performance increasing strategies? Are there any
special things to regard in a VM?

Kind regards

   Andreas.

--
http://fam-tille.de

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match

Re: [PERFORM] PostgreSQL in virtual machine

[Harald Armin Massa]

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.

---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org