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 78CC69DC899 for ; Mon, 6 Mar 2006 13:14:51 -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 56957-05 for ; Mon, 6 Mar 2006 13:14:50 -0400 (AST) Received: from hub.org (hub.org [200.46.204.220]) by postgresql.org (Postfix) with ESMTP id 49D839DC83A for ; Mon, 6 Mar 2006 13:14:49 -0400 (AST) Received: from localhost (unknown [200.46.204.144]) by hub.org (Postfix) with ESMTP id D7FCB62C982 for ; Mon, 6 Mar 2006 13:14:49 -0400 (AST) Received: from hub.org ([200.46.204.220]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 56262-06; Mon, 6 Mar 2006 13:14:47 -0400 (AST) Received: from ganymede.hub.org (blk-222-82-85.eastlink.ca [24.222.82.85]) by hub.org (Postfix) with ESMTP id 47FE962C967; Mon, 6 Mar 2006 13:14:47 -0400 (AST) Received: by ganymede.hub.org (Postfix, from userid 1000) id 013AA3ACB0; Mon, 6 Mar 2006 13:14:45 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id B0E2F3AC48; Mon, 6 Mar 2006 13:14:45 -0400 (AST) Date: Mon, 6 Mar 2006 13:14:45 -0400 (AST) From: "Marc G. Fournier" X-X-Sender: scrappy@ganymede.hub.org To: newz@bearfruit.org cc: Nagita Karunaratne , pgsql-performance@postgresql.org Subject: Re: Postgres on VPS - how much is enough? In-Reply-To: Message-ID: <20060306131355.A1227@ganymede.hub.org> References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.485 required=5 tests=[AWL=0.006, DNS_FROM_RFC_ABUSE=0.479] X-Spam-Score: 0.485 X-Spam-Level: X-Archive-Number: 200603/38 X-Sequence-Number: 17475 On Mon, 6 Mar 2006, Matthew Nuzum wrote: > 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 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? > > 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. We host VPSs here (http://www.hub.org) and don't use the 'single file, virtual file system' to put them into ... it must depend on where you host? ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664