Statistics Buffer is full

Поиск
Список
Период
Сортировка
Искать

Statistics Buffer is full

От:
Pallav Kalva <pkalva@deg.cc>
Дата:
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

Re: Statistics Buffer is full

От:
Bricklen Anderson <BAnderson@PresiNET.com>
Дата:
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.

Re: Statistics Buffer is full

От:
Bjoern Metzdorf <bm@turtle-entertainment.de>
Дата:
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)
> 
FAQ