X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B80FCD1B44D for ; Fri, 30 Jan 2004 08:06:56 +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 06101-05 for ; Fri, 30 Jan 2004 04:06:57 -0400 (AST) Received: from ecbull20.frec.bull.fr (ecbull20.frec.bull.fr [129.183.4.3]) by svr1.postgresql.org (Postfix) with ESMTP id 9F5D0D1D179 for ; Fri, 30 Jan 2004 04:06:50 -0400 (AST) Received: from ecn002.frec.bull.fr (ecn002.frec.bull.fr [129.183.4.6]) by ecbull20.frec.bull.fr (8.9.2/8.9.1) with ESMTP id JAA12592; Fri, 30 Jan 2004 09:07:17 +0100 Received: from BULL.NET ([129.183.148.134]) by ecn002.frec.bull.fr (Lotus Domino Release 5.0.12) with ESMTP id 2004013009114493:71 ; Fri, 30 Jan 2004 09:11:44 +0100 Message-ID: <401A10B7.D9307B90@BULL.NET> Date: Fri, 30 Jan 2004 09:07:19 +0100 From: Thierry Missimilly Organization: Bull Linux Center X-Mailer: Mozilla 4.75 [en] (Windows NT 5.0; U) X-Accept-Language: fr,en MIME-Version: 1.0 To: Juan Carlos Diez Cc: pgsql-admin@postgresql.org Subject: Re: Help: System requirements for postgresql 7.4.1 References: <00D95A04F3971D4A8828B241BF6144945086A0@exchange.eluniversal.com> X-MIMETrack: Itemize by SMTP Server on ECN002/FR/BULL(Release 5.0.12 |February 13, 2003) at 30/01/2004 09:11:45, Serialize by Router on ECN002/FR/BULL(Release 5.0.12 |February 13, 2003) at 30/01/2004 09:11:59, Serialize complete at 30/01/2004 09:11:59 Content-Type: multipart/mixed; boundary="------------DE7EF35CC407ABD6B939B138" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/290 X-Sequence-Number: 12153 This is a multi-part message in MIME format. --------------DE7EF35CC407ABD6B939B138 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, In fact it is difficult to answer to that questions as they depend of how big is your database, how many simultaneous connections you have, ... etc But, I can help you by giving you my results on a Bi-CPU Xeon 2.6 GHz , 4 Gb RAM, external 2 x RAID0 on four disks each with Redhat 9.0. 1) Connections : This system support easily 500 simultaneous connections. The performances decrease only by 11 % between 100 users and 500 users. 2) Database size : This is a bit more complex. If your database size is 700 Mb (less << RAM size) the performances are very good. But when the database size is bigger than the RAM size, the I/O increased rapidly and your system spend time in Wait I/O state. For example, I have noted that from 700 Mb to 7 Gb the performances drop by 65% on my 4 GB memory machine. That' s don't means they are bad but that means that if you want to improve performances on very big Database you should have to spend money to increase the I/O throughput instead of bought more CPUs. Please note that this remarks is valid on other RDBMS, even on commercial RDBMS. Please note too, that there is about 30 % of performance gain between SCSI internal disks and an external RAID0 Chaparral LUN. About the software, I have preferred to install my own downloaded Postgres 7.4 version as the Database Redhat package is a less recent Postgres version (7.2 or 7.3) and a lot of things have been improved in the 7.4. Further more, I prefer to install all Postgres bin and lib in /usr/local/pgsql than in /usr/bin and /usr/lib. Thierry Missimilly Juan Carlos Diez wrote: > Hello, I'm evaluating that version and I can't find system requirements for it. Could anybody please help me with these questions? > > 1.1. Hardware: > 1.1.1. C.P.U. (how many processors, what speed) > 1.1.2. Ram. (minimum and desired) > 1.1.3. Disk. > 1.1.4. Networking. > 1.1.5. Scalability > > 1.2. Software: > 1.2.1. OS. (wich versions and patches are required for linux and solaris) > 1.2.2. Required software packages. > > Thank you very much. > > Best regards, > > JCD. > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster --------------DE7EF35CC407ABD6B939B138 Content-Type: text/x-vcard; charset=us-ascii; name="THIERRY.MISSIMILLY.vcf" Content-Description: Card for Thierry Missimilly Content-Disposition: attachment; filename="THIERRY.MISSIMILLY.vcf" Content-Transfer-Encoding: 7bit begin:vcard n:Missimilly;Thierry tel;fax:+33 (0)4 76 29 78 78 tel;work:+33 (0)4 76 29 74 54 x-mozilla-html:FALSE url:http:\\www.bull.com org:Bull Research & Developpement OpenSource adr:;;Bull SA, 1, rue de provence - BP 208;ECHIROLLES;;38432;FRANCE version:2.1 email;internet:Thierry.Missimilly@bull.net x-mozilla-cpt:;24696 fn:Thierry Missimilly end:vcard --------------DE7EF35CC407ABD6B939B138--