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 858AD9DCB94 for ; Mon, 6 Mar 2006 09:28:00 -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 15628-08 for ; Mon, 6 Mar 2006 09:28:03 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.195]) by postgresql.org (Postfix) with ESMTP id 719029DCA22 for ; Mon, 6 Mar 2006 09:27:58 -0400 (AST) Received: by wproxy.gmail.com with SMTP id i7so1364378wra for ; Mon, 06 Mar 2006 05:28:02 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=hahOGNIM6kLDgVfMM+VVLKDpPBL7h7YgE1rC/Pp/bhO/P09UP3ZH8iXnOt4jRFWViMlKzQ+b/Z31Yp+LtGJipnXnJvGQ/EqgHP/QtQy/hQDp11JGLUhFHJ+2uTfivr9Qil3HdN8gvHjMyEcSkDyGkQqieIgRmlXiIuz7UWaiieU= Received: by 10.65.133.18 with SMTP id k18mr2582153qbn; Mon, 06 Mar 2006 05:28:02 -0800 (PST) Received: by 10.65.148.13 with HTTP; Mon, 6 Mar 2006 05:28:02 -0800 (PST) Message-ID: Date: Mon, 6 Mar 2006 05:28:02 -0800 From: "Nagita Karunaratne" To: pgsql-performance@postgresql.org Subject: Postgres on VPS - how much is enough? MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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/31 X-Sequence-Number: 17468 How big a VPS would I need to run a Postgres DB. I need a Postgres database with about 15 tables that will run on a single virtual private server. The 15 tables will be spread over three tablespaces (5 tables per tablespace) and be accessed by three different applications running on different machines. One application will add about 500 orders per day Another will access this data to create and send about 500 emails per day 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? It's been a long time since I used Postgres. Thanks for any help, Nagita