X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 62643B4276B for ; Sun, 6 Jul 2003 09:45:48 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 80814-04 for ; Sun, 6 Jul 2003 06:45:17 -0300 (ADT) Received: from smtp.pspl.co.in (www.pspl.co.in [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id 59AD4B42169 for ; Sun, 6 Jul 2003 06:45:15 -0300 (ADT) Received: (from root@localhost) by smtp.pspl.co.in (8.12.9/8.12.9) id h669k5xh031359 for ; Sun, 6 Jul 2003 15:16:05 +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 h669k58B031346 for ; Sun, 6 Jul 2003 15:16:05 +0530 From: "Shridhar Daithankar" To: Postgresql Performance Date: Sun, 06 Jul 2003 15:14:18 +0530 MIME-Version: 1.0 Subject: Re: Extreme high load averages Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3F083CCA.31144.7468C@localhost> In-reply-to: <3F07ABA1.2070100@ethereal-realms.org> 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-Spam-Checker-Version: SpamAssassin 2.54 (1.174.2.17-2003-05-11-exp) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/109 X-Sequence-Number: 2402 On 5 Jul 2003 at 22:54, Martin Foster wrote: > What I would like to know is. Why? The kernel has been compiled to > handle the number of concurrent connections, the server may not be the > best, but it should be able to handle the requests: PIII 1Ghz, 1GB > SDRAM, 2 IDE 20GB drives. > > I have changed settings to take advantage of the memory. So the > following settings are of interest: > shared_buffers = 16384 > wal_buffers = 256 > sort_mem = 16384 > vacuum_mem = 32768 As somebody else has already pointed out, your sort_mem is bit too high than required. Try lowering it. Secondly did you tune effective_cache_size? HTH Bye Shridhar -- Power, n.: The only narcotic regulated by the SEC instead of the FDA.