> Bug reference: 2581 > Logged by: David Azevedo > Email address: [EMAIL PROTECTED] > 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.
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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
