Skip site navigation (1) Skip section navigation (2)

Re: Statistics Buffer is full

From: Bjoern Metzdorf <bm(at)turtle-entertainment(dot)de>
To: Pallav Kalva <pkalva(at)deg(dot)cc>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Statistics Buffer is full
Date: 2005-05-06 16:38:14
Message-ID: 427B9D76.5060904@turtle-entertainment.de (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)postgresql(dot)org)
> 

In response to

pgsql-admin by date

Next:From: Michael LongDate: 2005-05-06 17:33:53
Subject: Re: Need help in data migration
Previous:From: Bricklen AndersonDate: 2005-05-06 14:03:21
Subject: Re: Statistics Buffer is full

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group