Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 9E90B2E0044 for ; Tue, 26 Feb 2008 13:34:34 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 99653-02 for ; Tue, 26 Feb 2008 13:34:29 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from smtpauth.rollernet.us (smtpauth.rollernet.us [208.11.75.5]) by postgresql.org (Postfix) with ESMTP id 6BA0F2E016F for ; Tue, 26 Feb 2008 13:33:46 -0400 (AST) Received: from smtpauth.rollernet.us (localhost.localdomain [127.0.0.1]) by smtpauth.rollernet.us (Postfix) with ESMTP id C2EF359417F; Tue, 26 Feb 2008 09:33:43 -0800 (PST) Received: from iron.denterprises.org (ool-4350518d.dyn.optonline.net [67.80.81.141]) by smtpauth.rollernet.us (Postfix) with ESMTP; Tue, 26 Feb 2008 09:33:43 -0800 (PST) Received: from lamp.iron.denterprises.org (lamp.iron.denterprises.org [192.168.171.84]) by iron.denterprises.org (Postfix) with ESMTP id C05AF16767D; Tue, 26 Feb 2008 12:33:42 -0500 (EST) Message-ID: <47C44D7A.5040904@denterprises.org> Date: Tue, 26 Feb 2008 12:33:46 -0500 From: Colin Wetherbee User-Agent: Thunderbird 2.0.0.9 (Macintosh/20071031) MIME-Version: 1.0 To: TJ O'Donnell CC: pgsql-general@postgresql.org Subject: Re: [SQL] Deploying PostgreSQL on virtualized hardware References: <47C42897.7010202@acm.org> In-Reply-To: <47C42897.7010202@acm.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Rollernet-Abuse: Processed by Roller Network Mail Services. Contact abuse@rollernet.us to report violations. Abuse policy: http://rollernet.us/abuse.php X-Rollernet-Submit: Submit ID 4817.47c44d77.9b2d4.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/1283 X-Sequence-Number: 129093 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