From: | TJ O'Donnell <tjo(at)acm(dot)org> |
---|---|
To: | PostgreSQL - SQL <pgsql-sql(at)postgresql(dot)org>, cww(at)denterprises(dot)org |
Subject: | Re: Deploying PostgreSQL on virtualized hardware |
Date: | 2008-02-26 14:56:23 |
Message-ID: | 47C42897.7010202@acm.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
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.
> 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Hermann Muster | 2008-02-26 15:07:23 | dbi_link and dbi:ODBC |
Previous Message | Stuart Brooks | 2008-02-26 14:49:56 | Re: autovacuum not freeing up unused space on 8.3.0 |
From | Date | Subject | |
---|---|---|---|
Next Message | Teemu Torma | 2008-02-26 15:17:39 | Re: duplicate key violates unique constraint |
Previous Message | Shavonne Marietta Wijesinghe | 2008-02-26 14:55:42 | duplicate key violates unique constraint |