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.
---------------------------(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
