Re: Deploying PostgreSQL on virtualized hardware

[TJ O'Donnell <tjo(at)acm(dot)org>]

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.