PostgreSQL in virtual machine - Mailing list pgsql-performance

From Andreas Tille
Subject PostgreSQL in virtual machine
Date
Msg-id Pine.LNX.4.62.0703120919450.26538@wr-linux02
Whole thread Raw
Responses Re: PostgreSQL in virtual machine
Re: PostgreSQL in virtual machine
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:

Previous
From: Scott Marlowe
Date:
Subject: Re: configuring new server / many slow disks?
Next
From: "Harald Armin Massa"
Date:
Subject: Re: PostgreSQL in virtual machine