PostgreSQL in virtual machine

From: Andreas Tille
Subject: PostgreSQL in virtual machine
Date: ,
Msg-id: Pine.LNX.4.62.0703120919450.26538@wr-linux02
(view: Whole thread, Raw)
Responses: Re: PostgreSQL in virtual machine  ("Harald Armin Massa")
Re: PostgreSQL in virtual machine  (Cosimo Streppone)
List: pgsql-performance

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


pgsql-performance by date:

From: Andreas Tille
Date:
Subject: PostgreSQL in virtual machine
From: "Harald Armin Massa"
Date:
Subject: Re: PostgreSQL in virtual machine