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 48DBAD1B445 for ; Wed, 3 Dec 2003 19:24: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 85877-03 for ; Wed, 3 Dec 2003 15:23:35 -0400 (AST) Received: from smtp.istop.com (dci.doncaster.on.ca [66.11.168.194]) by svr1.postgresql.org (Postfix) with ESMTP id 50678D1B446 for ; Wed, 3 Dec 2003 15:23:34 -0400 (AST) Received: from stark.xeocode.com (gsstark.mtl.istop.com [66.11.160.162]) by smtp.istop.com (Postfix) with ESMTP id 23E5236CB8; Wed, 3 Dec 2003 14:23:33 -0500 (EST) Received: from localhost ([127.0.0.1] helo=stark.dyndns.tv ident=foobar) by stark.xeocode.com with smtp (Exim 3.36 #1 (Debian)) id 1ARcaz-00021S-00; Wed, 03 Dec 2003 14:23:33 -0500 To: "scott.marlowe" Cc: , Subject: Re: Minimum hardware requirements for Postgresql db References: In-Reply-To: From: Greg Stark Organization: The Emacs Conspiracy; member since 1992 Date: 03 Dec 2003 14:23:32 -0500 Message-ID: <87smk166yz.fsf@stark.dyndns.tv> Lines: 26 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.3 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/50 X-Sequence-Number: 4910 "scott.marlowe" writes: > > 3) Estimated number of transactions to be written into the Postgresql db is > > around 15000 records per day. > > > > The growth rate in terms of number of connections is around 10% per year > > and the data retention is kept on average at least for 18 months for the 2 > > databases. > Like another poster pointed out, this is a walk in the park for > postgresql. My workstation (1.1GHz celeron, 40 gig IDE drive, 512 Meg > memory) could handle this load while still being my workstation. Well there's some info missing. Like what would you actually be _doing_ with these data? 15,000 inserts per day is nothing. But after 18 months that's over 5M records not including the 10% growth rate. 5M records isn't really all that much but it's enough that it's possible to write slow queries against it. If you're doing big batch updates or complex reports against the data that will be more interesting than the inserts. -- greg