pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Deploying PostgreSQL on virtualized hardware
2+ messages / 2 participants
[nested] [flat]
* Re: Deploying PostgreSQL on virtualized hardware
@ 2008-02-26 14:56 TJ O'Donnell <tjo@acm.org>
2008-02-26 17:33 ` Re: [SQL] Deploying PostgreSQL on virtualized hardware Colin Wetherbee <cww@denterprises.org>
0 siblings, 1 reply; 2+ messages in thread
From: TJ O'Donnell @ 2008-02-26 14:56 UTC (permalink / raw)
To: pgsql-sql; cww@denterprises.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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [SQL] Deploying PostgreSQL on virtualized hardware
2008-02-26 14:56 Re: Deploying PostgreSQL on virtualized hardware TJ O'Donnell <tjo@acm.org>
@ 2008-02-26 17:33 ` Colin Wetherbee <cww@denterprises.org>
0 siblings, 0 replies; 2+ messages in thread
From: Colin Wetherbee @ 2008-02-26 17:33 UTC (permalink / raw)
To: TJ O'Donnell <tjo@acm.org>; +Cc: pgsql-general@postgresql.org
TJ O'Donnell wrote:
> 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.
TJ,
Thanks for your input. I was asking more about hosted elastic
servers, like those provided by the Xen hypervisor, though.
(BTW, how did this end up on the SQL list? I'm going to put it back
on the general list. :) )
Colin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-02-26 17:33 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-02-26 14:56 Re: Deploying PostgreSQL on virtualized hardware TJ O'Donnell <tjo@acm.org>
2008-02-26 17:33 ` Colin Wetherbee <cww@denterprises.org>
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