X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 87851D1B4E0 for ; Wed, 3 Dec 2003 19:32:06 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 87175-03 for ; Wed, 3 Dec 2003 15:31:35 -0400 (AST) Received: from localhost.localdomain (dsl093-038-087.pdx1.dsl.speakeasy.net [66.93.38.87]) by svr1.postgresql.org (Postfix) with ESMTP id 22D19D1BC5C for ; Wed, 3 Dec 2003 15:31:34 -0400 (AST) Received: from commandprompt.com (tacodog [127.0.0.1]) by localhost.localdomain (8.12.8/8.12.8) with ESMTP id hB3JVQFj027627 for ; Wed, 3 Dec 2003 11:31:27 -0800 Message-ID: <3FCE3A0E.8050206@commandprompt.com> Date: Wed, 03 Dec 2003 11:31:26 -0800 From: Al Hulaton User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.5) Gecko/20031014 Thunderbird/0.3 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Minimum hardware requirements for Postgresql db References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/51 X-Sequence-Number: 4911 > 1) We will be running 2 x Postgresql db in the machine. > > 2) Total number of connections to be around 100. The connections from the > clients machines will be in ODBC and socket connections. > > 3) Estimated number of transactions to be written into the Postgresql db is > around 15000 records per day. Assuming this server will be dedicated to PostgreSQL only, the needs outlined above are modest. As was pointed out in other posts, a simple sub-ghz machine with 512mb of ram is more than enough, but I'd slap on a gig only because RAM is cheaper now. If the database on this server is crucial, I'd look at setting up a UPS, RAID (at this level, even software-based RAID will do fine, RAID 5 preferably) and investing in a backup/replicator solution. -- Best, Al Hulaton | Sr. Account Engineer | Command Prompt, Inc. 503.667.4564 | ahulaton@commandprompt.com Home of Mammoth Replicator for PostgreSQL Managed PostgreSQL, Linux services and consulting Read and Search O'Reilly's 'Practical PostgreSQL' at http://www.commandprompt.com