X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.225.181]) by svr1.postgresql.org (Postfix) with ESMTP id 14A09CBB3A for ; Tue, 15 Jul 2003 05:41:04 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr5.postgresql.org [64.117.225.181]) (amavisd-new, port 10024) with ESMTP id 54277-03 for ; Tue, 15 Jul 2003 05:41:20 +0000 (GMT) Received: from smtp.pspl.co.in (unknown [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id 9BD32CB56E for ; Tue, 15 Jul 2003 02:40:51 -0300 (ADT) Received: (from root@localhost) by smtp.pspl.co.in (8.12.9/8.12.9) id h6F5iblG032743 for ; Tue, 15 Jul 2003 11:14:37 +0530 Received: from daithan (daithan.intranet.pspl.co.in [192.168.7.161]) (authenticated bits=0) by smtp.pspl.co.in (8.12.9/8.12.9) with ESMTP id h6F5iaKr032697 for ; Tue, 15 Jul 2003 11:14:36 +0530 From: "Shridhar Daithankar" To: "Pgsql-Performance@Postgresql. Org" Date: Tue, 15 Jul 2003 11:12:10 +0530 MIME-Version: 1.0 Subject: Re: Sanity check requested Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3F13E18A.21241.4B86CB0@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/231 X-Sequence-Number: 2524 On 14 Jul 2003 at 12:51, Nick Fankhauser wrote: > Any thoughts? Is this a sane plan? Are there other parameters I should > consider changing first? Well, everything seems to be in order and nothing much to suggest I guess. But still.. 1. 30 users does not seem to be much of a oevrhead. If possible try doing away with connection pooling. Buta test benchmark run is highly recommended. 2. While increasing sort memory, try 4/8/16 in that order. That way you will get a better picture of load behaviour. Though whatever you put appears reasonable, having more data always help. 3. I don't know how this affects on SCSI drives, but what file system you are using? Can you try diferent ones? Like reiserfs/ext3 and XFS? See what fits your bill. 4. OK, this is too much but linux kernel 2.6 is in test and has vastly improved IO scheduler. May be you should look at it if you are up to experimentation. HTH Bye Shridhar -- You're dead, Jim. -- McCoy, "The Tholian Web", stardate unknown