X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 109AE52A62 for ; Fri, 6 May 2005 13:38:46 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 40804-05 for ; Fri, 6 May 2005 16:38:37 +0000 (GMT) Received: from ns1.turtle-entertainment.de (ns1.turtle-entertainment.de [193.41.200.20]) by svr1.postgresql.org (Postfix) with ESMTP id BF70452949 for ; Fri, 6 May 2005 13:38:35 -0300 (ADT) Received: from 173-172-20-212.dsl.globvill.de ([212.20.172.173] helo=mail.office.turtle-entertainment.de) by ns1.turtle-entertainment.de with asmtp (Exim 3.22 #3 (Debian)) id 1DU5qD-0006YH-00; Fri, 06 May 2005 18:38:17 +0200 Received: from p54992cfe.dip0.t-ipconnect.de ([84.153.44.254] helo=[192.168.35.188]) by mail.office.turtle-entertainment.de with asmtp (Exim 3.22 #7 (Debian)) id 1DU5qC-0001FC-00; Fri, 06 May 2005 18:38:17 +0200 Message-ID: <427B9D76.5060904@turtle-entertainment.de> Date: Fri, 06 May 2005 18:38:14 +0200 From: Bjoern Metzdorf User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Pallav Kalva Cc: pgsql-admin@postgresql.org Subject: Re: Statistics Buffer is full References: <427B6D05.7000708@deg.cc> In-Reply-To: <427B6D05.7000708@deg.cc> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200505/68 X-Sequence-Number: 17497 this applies to 7.x only: raise PGSTAT_RECVBUFFERSZ in /src/include/pgstat.h (i.e. raise 1024 to 16384) Performance drops will go away then (at least in my case here). Regards Bjoern Pallav Kalva wrote: > Hi Everybody, > > > I got this logged in my log file last night on my production database > while doing vacuumdb with analyze option , is this normal ? does it > affect the system anyway ? is there anyway to get rid of these messages ? > > 2005-05-06 00:31:03 EDT%%% LOG: statistics buffer is full > 2005-05-06 00:31:15 EDT%%% LOG: statistics buffer is full > 2005-05-06 00:31:15 EDT%%% LOG: statistics buffer is full > 2005-05-06 00:31:15 EDT%%% LOG: statistics buffer is full > 2005-05-06 00:31:15 EDT%%% LOG: statistics buffer is full > > > Thanks! > Pallav > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >