X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 20B42D1CA63 for ; Thu, 20 Nov 2003 05:58:51 +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 59838-01 for ; Thu, 20 Nov 2003 01:58:20 -0400 (AST) Received: from smtp-send.myrealbox.com (smtp-send.myrealbox.com [192.108.102.143]) by svr1.postgresql.org (Postfix) with ESMTP id E1F9DD1B592 for ; Thu, 20 Nov 2003 01:58:18 -0400 (AST) Received: from myrealbox.com shridhar_daithankar@smtp-send.myrealbox.com [202.54.11.72] by smtp-send.myrealbox.com with NetMail SMTP Agent $Revision: 3.44 $ on Novell NetWare via secured & encrypted transport (TLS); Wed, 19 Nov 2003 22:58:19 -0700 Message-ID: <3FBC57F5.8070705@myrealbox.com> Date: Thu, 20 Nov 2003 11:28:13 +0530 From: Shridhar Daithankar User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5) Gecko/20031013 Thunderbird/0.3 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Benjamin Bostow , Performance Subject: Re: High Processor consumption References: <1069204784.1955.16.camel@localhost.localdomain> <3FBB0EE4.6010805@myrealbox.com> <1069264247.1955.25.camel@localhost.localdomain> In-Reply-To: <1069264247.1955.25.camel@localhost.localdomain> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/171 X-Sequence-Number: 4731 Benjamin Bostow wrote: > I haven't modified any of the setting. I did try changing shmmax from > 32MB to 256MB but didn't see much change in the processor usage. The > init script that runs to start the server uses the following: > su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p > /usr/bin/postmaster -o \"-i -N 128 -B 256\" start > /dev/null 2>&1" < > /dev/null Lol.. -B 256 does not mean 256MB of buffers. It means 2MB of buffers. Each buffer is of 8K. Try upping it to a 1000 or 2000 > > I haven't modified postgresql.conf yet but am going through a book on > performance tuning the server. If you can provide any suggestions or > help as I am new to postgres it would be appreciated. http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html HTH Shridhar