From: TJ O'Donnell <tjo@acm.org>
To: PostgreSQL - SQL <pgsql-sql@postgresql.org>
To: cww@denterprises.org
Subject: Re: Deploying PostgreSQL on virtualized hardware
Date: Tue, 26 Feb 2008 06:56:23 -0800
Message-ID: <47C42897.7010202@acm.org> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tjo@acm.org, cww@denterprises.org
Subject: Re: Deploying PostgreSQL on virtualized hardware
In-Reply-To: <47C42897.7010202@acm.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox