BUG #6229: Postgresql crashes after: LOG: statistics buffer is full
От | Max Kunz |
---|---|
Тема | BUG #6229: Postgresql crashes after: LOG: statistics buffer is full |
Дата | |
Msg-id | 201109271650.p8RGovgW053195@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #6229: Postgresql crashes after: LOG: statistics buffer is full
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 6229 Logged by: Max Kunz Email address: admin@m4ximus.de PostgreSQL version: 8.1.3 Operating system: Suse Description: Postgresql crashes after: LOG: statistics buffer is full Details: Hello, i have detected a problem after postgres logs "statistics buffer is full": The database achieves farther on connections from the clients but no one could process a statement and neither of the connection was closed. It was also not possible to shutdown postgresql regularly. Is there a dependence on statistics buffer, while processing statements? I've read a lot about similar problems on the internet, but could not finde a satisfying solution. Is that a known problem? Here is the statistic collector configuration: # - Query/Index Statistics Collector - stats_start_collector = on stats_command_string = on #stats_block_level = off stats_row_level = on #stats_reset_on_server_start = off I need the collector to perform autovacuum. Is it helpful to disable the command_string? I am very greatful for any idea to avoid this problem in future. best regards, Max
В списке pgsql-bugs по дате отправления: