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 9375552972 for ; Fri, 6 May 2005 11:03:34 -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 15986-03 for ; Fri, 6 May 2005 14:03:24 +0000 (GMT) Received: from presinet-main.presinet.com (unknown [209.53.156.1]) by svr1.postgresql.org (Postfix) with ESMTP id 7F63453217 for ; Fri, 6 May 2005 11:03:23 -0300 (ADT) Received: from [10.10.1.151] (BRICK [10.10.1.151]) by presinet-main.presinet.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2658.3) id KJAKKKLJ; Fri, 6 May 2005 07:00:18 -0700 Message-ID: <427B7929.1070506@PresiNET.com> Date: Fri, 06 May 2005 07:03:21 -0700 From: Bricklen Anderson User-Agent: Debian Thunderbird 1.0.2 (X11/20050331) 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.029 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/66 X-Sequence-Number: 17495 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 > I frequently see the same message in my logs when doing a bulk load (6-8 million rows). I'm interested in knowing what the message is as well.