Re: BUG #2581: Statistics buffer is full

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: BUG #2581: Statistics buffer is full
Дата
Msg-id 6BCB9D8A16AC4241919521715F4D8BCEA0FB4A@algol.sollentuna.se
обсуждение исходный текст
Ответ на BUG #2581: Statistics buffer is full  ("David Azevedo" <davixz@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Dan Franklin
Дата:
Сообщение: Re: BUG #2579: initcap should not capitalize letter
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #2581: Statistics buffer is full