X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id A245DD1C510 for ; Thu, 24 Jul 2003 13:07:41 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 37363-05 for ; Thu, 24 Jul 2003 10:07:00 -0300 (ADT) Received: from smtp.pspl.co.in (unknown [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id C1A2AD1C50F for ; Thu, 24 Jul 2003 10:07:38 -0300 (ADT) Received: (from root@localhost) by smtp.pspl.co.in (8.12.9/8.12.9) id h6ODDg4u026226 for ; Thu, 24 Jul 2003 18:43:42 +0530 Received: from daithan (daithan.intranet.pspl.co.in [192.168.7.161]) (authenticated bits=0) by persistent.co.in (8.12.9/8.12.9) with ESMTP id h6ODDfRZ026213 for ; Thu, 24 Jul 2003 18:43:41 +0530 From: "Shridhar Daithankar" To: pgsql-performance@postgresql.org Date: Thu, 24 Jul 2003 18:39:26 +0530 MIME-Version: 1.0 Subject: Re: hardware performance and some more Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3F2027DE.15489.A17C705@localhost> In-reply-to: X-mailer: Pegasus Mail for Windows (v4.12a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/403 X-Sequence-Number: 2696 On 24 Jul 2003 at 15:54, Kasim Oztoprak wrote: > The questions for this explanation are: > 1 - Can we use postgresql within clustered environment? > 2 - if the answer is yes, in which method can we use postgresql within a cluster? > active - passive or active - active? Coupled with linux-HA( See http://linux-ha.org) heartbeat service, it *should* be possible to run postgresql in active-passive clustering. If postgresql supported read-only database so that several nodes could read off a single disk but only one could update that, a sort of active-active should be possible as well. But postgresql can not have a read only database. That would be a handy addition in such cases.. > Now, the second question is related to the performance of the database. Assuming we have a > dell's poweredge 6650 with 4 x 2.8 Ghz Xeon processors having 2 MB of cache for each, with the > main memory of lets say 32 GB. We can either use a small SAN from EMC or we can put all disks > into the machines with the required raid confiuration. > > We will install RedHat Advanced Server 2.1 to the machine as the operating system and postgresql as > the database server. We have a database having 25 millions records having the length of 250 bytes > on average for each record. And there are 1000 operators accessing the database concurrently. The main > operation on the database (about 95%) is select rather than insert, so do you have any idea about > the performance of the system? Assumig 325 bytes per tuple(250 bytes field+24-28 byte header+varchar fields) gives 25 tuples per 8K page, there would be 8GB of data. This configuration could fly with 12-16GB of RAM. After all data is read that is. You can cut down on other requirements as well. May be a 2x opteron with 16GB RAMmight be a better fit but check out how much CPU cache it has. A grep -rwn across data directory would fill the disk cache pretty well..:-) HTH Bye Shridhar -- Egotism, n: Doing the New York Times crossword puzzle with a pen.Egotist, n: A person of low taste, more interested in himself than me. -- Ambrose Bierce, "The Devil's Dictionary"