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 E1C41D1B8BD for ; Wed, 27 Aug 2003 03:58:51 -0300 (ADT) 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 15832-09 for ; Wed, 27 Aug 2003 03:58:42 -0300 (ADT) Received: from smtp.pspl.co.in (unknown [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id 6BBDED1B948 for ; Wed, 27 Aug 2003 03:58:39 -0300 (ADT) Received: (from root@localhost) by smtp.pspl.co.in (8.12.9/8.12.9) id h7R72oLv014592 for ; Wed, 27 Aug 2003 12:32:50 +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 h7R72ohi014579 for ; Wed, 27 Aug 2003 12:32:50 +0530 From: "Shridhar Daithankar" To: pgsql-performance@postgresql.org Date: Wed, 27 Aug 2003 12:30:33 +0530 MIME-Version: 1.0 Subject: Re: 8 way Intel Xeon system Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3F4CA469.27749.32D48FD@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: 200308/349 X-Sequence-Number: 3165 On 27 Aug 2003 at 14:07, Castle, Lindsay wrote: > I'm mainly interested in what I should concentrate on from a > Linux/PostgreSQL config point of view to see if we can take advantage of the > extra CPUs. - Yes it's overkill but this is a piece of surplus hardware we > don't have to buy. First of all whatever you do, add multiple connections using a middle layer. That will keep your CPU busy. Of course there are few things need to be done over single connection but this should help at least in some scenarios. > Perhaps some may say Linux isn't the best option for an 8 CPU server but > this is what I have to work with for reasons we won't get into :-) I think if you can afford a performance benchmark trial, give 2.6.0-testx a try. They should be much better than 2.4.x. > The current usage is along the lines of a few thousands updates spread over > the space of a few hours in the morning then followed by a thousand select > queries to do some reporting. In case of such IO intensive and update/delete heavy load, might be a good idea to move WAL to a separate SCSI channel. I believe merely moving it to another drive would not yield as much boost. > Currently RedHat 9 with PostgreSQL 7.3.2 installed. Get 7.4CVS head. and don't forget to use a autovacuum daemon. It's in contrib dir. HTH Bye Shridhar -- Ogden's Law: The sooner you fall behind, the more time you have to catch up.