X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CB503D1B2A8 for ; Wed, 9 Jun 2004 13:37:46 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 05592-04 for ; Wed, 9 Jun 2004 16:37:45 +0000 (GMT) Received: from mpls-qmqp-04.inet.qwest.net (mpls-qmqp-04.inet.qwest.net [63.231.195.115]) by svr1.postgresql.org (Postfix) with SMTP id D71F9D1B19A for ; Wed, 9 Jun 2004 13:37:43 -0300 (ADT) Received: (qmail 50388 invoked by uid 0); 9 Jun 2004 16:37:44 -0000 Received: from mpls-pop-08.inet.qwest.net (63.231.195.8) by mpls-qmqp-04.inet.qwest.net with QMQP; 9 Jun 2004 16:37:44 -0000 Received: from 63-227-127-37.dnvr.qwest.net (HELO ?10.0.0.2?) (63.227.127.37) by mpls-pop-08.inet.qwest.net with SMTP; 9 Jun 2004 16:37:44 -0000 Date: Wed, 09 Jun 2004 10:38:19 -0600 Message-Id: <1086799099.23855.17.camel@localhost.localdomain> From: "Scott Marlowe" To: "Milosz Miecznik" Cc: pgsql-admin@postgresql.org Subject: Re: PostgreSQL Performance In-Reply-To: <003401c44e2e$db738660$9801a8c0@MGA.local> References: <003401c44e2e$db738660$9801a8c0@MGA.local> Content-Type: text/plain Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/119 X-Sequence-Number: 13779 On Wed, 2004-06-09 at 08:34, Milosz Miecznik wrote: > Hi! > > I have very important question about performance of PostgreSQL Database. How > it will work with: > - about 3000000 insert operation per day, > - about 1000000 selects per day, > - about 100 still connected users? > What hardware platform shall I use for such big database (RAM, No. of CPUs, > Hard discs capasity...?) > What operating system shall I use? (I think about RedHat 8.x) In acceptance testing on a dual 2.8 GHz P4 with 2 gigs ram and a pair of UWSCSI drives running under an LSI/MegaRAID320 controller, with pg_autovacuum running in the background, I was able to handle 10,000,000 transactions in 12 hours. That was with 250 simo connections running 40,000 transactions each. Now, how big are your inserts? If they're reasonable small, like financial info, then you can easily handle 3M inserts a day. If they're really complex and have lots of constraints or FKs to deal with, then maybe not. But a Dual P4 with 2 gigs ram and a pair of mirrored hard drives is kinda an entry level db server nowadays. A machine with more disk bandwidth could probably handle quite a bit more.