X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 023839DCC4C for ; Mon, 6 Mar 2006 10:56:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 33221-01 for ; Mon, 6 Mar 2006 10:56:02 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.207]) by postgresql.org (Postfix) with ESMTP id 29A809DCA8F for ; Mon, 6 Mar 2006 10:55:55 -0400 (AST) Received: by xproxy.gmail.com with SMTP id t11so797525wxc for ; Mon, 06 Mar 2006 06:56:00 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=JjOPMxIlGFLLRi5ZF6NC6uszmtuCTliUyezj1qJJjHNhDtA6edokbKlGUwsNcEYJcQNcrbhIUjhIaAXdFDOBiI11aDOYuzHu5jyiUXCOzoitOaJneS4ced9XJmcSE3YmPR5v5Fi4NxEP8/zJpVBJN8YQRzgP2hcKZ9zfuJMgsEA= Received: by 10.70.54.13 with SMTP id c13mr7387389wxa; Mon, 06 Mar 2006 06:56:00 -0800 (PST) Received: by 10.70.128.2 with HTTP; Mon, 6 Mar 2006 06:56:00 -0800 (PST) Message-ID: Date: Mon, 6 Mar 2006 08:56:00 -0600 From: "Matthew Nuzum" Reply-To: newz@bearfruit.org To: "Nagita Karunaratne" Subject: Re: Postgres on VPS - how much is enough? Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200603/34 X-Sequence-Number: 17471 On 3/6/06, Nagita Karunaratne wrote: > How big a VPS would I need to run a Postgres DB. > > One application will add about 500 orders per day > Another will access this data to create and send about 500 emails per da= y > A third will access this data to create an after-sales survey for at > most 500 times per day. > > What type of VPS would I need to run a database with this type pf load? > Is 128 MB ram enough? > What percentage of a 2.8 GHz CPU would be required? My problem with running PG inside of a VPS was that the VPS used a virtual filesystem... basically, a single file that had been formatted and loop mounted so that it looked like a regular hard drive. Unfortunately, it was very slow. The difference between my application and yours is that mine well more than filled the 1GB of RAM that I had allocated. If your data will fit comfortably into RAM then you may be fine. If you really want to know how it will work, try running it yourself. Two projects that make this really easy and free is the colinux project[1] which allows you to run a linux VPS in Windows and the linux-vserver project[2] which is free software that works on pretty much any linux OS. Try it out, tinker with the values and that way you won't have to guess when making your purchase decission. [1] http://www.colinux.org/ Coperative Linux [2] http://linux-vserver.org/ Linux-vserver project -- Matthew Nuzum www.bearfruit.org