Re: BUG #2581: Statistics buffer is full - Mailing list pgsql-bugs

From Magnus Hagander
Subject Re: BUG #2581: Statistics buffer is full
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCEA0FB4A@algol.sollentuna.se
Whole thread Raw
In response to BUG #2581: Statistics buffer is full  ("David Azevedo" <davixz@gmail.com>)
List pgsql-bugs
> 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

pgsql-bugs by date:

Previous
From: Dan Franklin
Date:
Subject: Re: BUG #2579: initcap should not capitalize letter
Next
From: Tom Lane
Date:
Subject: Re: BUG #2581: Statistics buffer is full