Обсуждение: BUG #2581: Statistics buffer is full

The following bug has been logged online:

Bug reference:      2581
Logged by:          David Azevedo
Email address:      davixz@gmail.com
PostgreSQL version: 8.1.4
Operating system:   windows 2003 server
Description:        Statistics buffer is full
Details:

Guys my problem is that my postgre crashes like 5 times in a day. In the log
i see these messages ( statistics buffer is full ), may be it the problem? i
read about and found people with this report on 7.xx versions and called it
a bug solved. but i got this in 8.1.4 .i thought once that unclosed
connections may be the problem and set the connection log, but all the
connections seems to be opening and closing. Thank you in advance and for
this fantastic job on this database.

> Bug reference:      2581
> Logged by:          David Azevedo
> Email address:      davixz@gmail.com
> PostgreSQL version: 8.1.4
> Operating system:   windows 2003 server
> Description:        Statistics buffer is full
> Details:=20
>=20
> Guys my problem is that my postgre crashes like 5 times in a=20
> day. In the log i see these messages ( statistics buffer is=20
> full ), may be it the problem? i read about and found people=20
> with this report on 7.xx versions and called it a bug solved.=20
> but i got this in 8.1.4 .i thought once that unclosed=20
> connections may be the problem and set the connection log,=20
> but all the connections seems to be opening and closing.=20
> Thank you in advance and for this fantastic job on this database.

It could definitly be related. There are some stats related bugs fixed
in HEAD (I don't think it's backpatched, and it's definitly not in a
released version).

If you don't need the stats, try turning off them - specifically the row
level stats - in postgresql.conf. Beware that turning these off will
disable autovacuum if you are using that one. but it's worth testing to
see if it solves your issue.

//Magnus

"David Azevedo" <davixz@gmail.com> writes:
> Guys my problem is that my postgre crashes like 5 times in a day.

Define "crash" --- what happens, *exactly* ?

> In the log
> i see these messages ( statistics buffer is full ), may be it the problem?

This is not a crash, merely an indicator of high load.

            regards, tom lane