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 216B0D1B1CE for ; Wed, 9 Jun 2004 11:30:21 -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 29619-07 for ; Wed, 9 Jun 2004 14:30:16 +0000 (GMT) Received: from ish2.mga.com.pl (ish2.mga.com.pl [83.16.203.26]) by svr1.postgresql.org (Postfix) with ESMTP id 73FC1D1B192 for ; Wed, 9 Jun 2004 11:30:11 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by ish2.mga.com.pl (Postfix) with ESMTP id D52E4DAF82 for ; Wed, 9 Jun 2004 16:30:06 +0200 (CEST) Received: from ish2.mga.com.pl ([127.0.0.1]) by localhost (ish2 [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 20229-01 for ; Wed, 9 Jun 2004 16:30:02 +0200 (CEST) Received: from michoo (ahv27.internetdsl.tpnet.pl [83.16.203.27]) by ish2.mga.com.pl (Postfix) with ESMTP id 51FD0DAF80 for ; Wed, 9 Jun 2004 16:30:02 +0200 (CEST) Message-ID: <003401c44e2e$db738660$9801a8c0@MGA.local> Reply-To: "Milosz Miecznik" From: "Milosz Miecznik" To: Subject: PostgreSQL Performance Date: Wed, 9 Jun 2004 16:34:22 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-Virus-Scanned: by amavisd-new & mks-vir at mga.com.pl 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/114 X-Sequence-Number: 13774 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) Can You help and reply to me, please. Milosz Miecznik