Message-ID: <47C42897.7010202@acm.org>
Date: Tue, 26 Feb 2008 06:56:23 -0800
From: TJ O'Donnell <tjo@acm.org>
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
MIME-Version: 1.0
To: PostgreSQL - SQL <pgsql-sql@postgresql.org>, cww@denterprises.org
Subject: Re: Deploying PostgreSQL on virtualized hardware
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I've been running PostgreSQL on a virtual server for
several years now.  I'm using VMWare with a Windows
host and Linux guest.  I've configured it to let Linux
use a raw partition as a disk.  Before I used a
separate partition, the virtual disk had been a
Windows file.  Using the disk partition increased
performance, but I don't recall now exactly how much.
This is a small setup with a handful of users.
The database contains only dozens of tables,
but some have ~8 million rows.  I've allocated
1Mb of RAM to the virtual machine.

Hope this helps.

TJ
http://www.gnova.com

> In a couple months, I'm going to be considering how best to deploy an 
> application I have that uses PostgreSQL as its back-end.  It also makes 
> heavy use of Perl under mod_perl and UMN MapServer with a sprinkling of 
> PostGIS.