Re: [SQL] Deploying PostgreSQL on virtualized hardware

From: Colin Wetherbee <cww(at)denterprises(dot)org>
To: TJ O'Donnell <tjo(at)acm(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [SQL] Deploying PostgreSQL on virtualized hardware
Date: 2008-02-26 17:33:46
Message-ID: 47C44D7A.5040904@denterprises.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Stark 2008-02-26 18:15:06 Re: unnesesary sorting after Merge Full Join
Previous Message Gregory Stark 2008-02-26 17:26:34 Re: Query meltdown: caching results

Browse pgsql-sql by date

  From Date Subject
Next Message Professor Flávio Brito 2008-02-26 18:20:39 Re: Function returns error (view)
Previous Message Rodrigo E. De León Plicet 2008-02-26 17:09:28 Re: duplicate key violates unique constraint