Re: autovacuum question

Поиск
Список
Период
Сортировка
От Thomas Pundt
Тема Re: autovacuum question
Дата
Msg-id 200704050919.44002.mlists@rp-online.de
обсуждение исходный текст
Ответ на Re: autovacuum question  (Carol Walter <walterc@indiana.edu>)
Список pgsql-admin
On Wednesday 04 April 2007 20:40, Carol Walter wrote:
| Hi, I'm looking in my log file with today's date.  I'm using VIM and
| have done a search for a pattern match on "autovac", "vacuum", and
| "auto"  VIM returned "string not found" for each search.  Am I
| looking for the wrong  string, or is there another log file I should
| be looking at?

No; mine has entries like

[::2007-04-05 09:04:10 CEST] LOG:  autovacuum: processing database "postgres"

and the only settings different from default are

  log_min_error_statement = warning
  log_min_duration_statement = 1000
  log_line_prefix = '[%u:%d:%t] '

  autovacuum = on
  autovacuum_naptime = 30
  autovacuum_vacuum_threshold = 500
  autovacuum_analyze_threshold = 250
  autovacuum_vacuum_scale_factor = 0.2
  autovacuum_analyze_scale_factor = 0.1

Ciao,
Thomas

--
Thomas Pundt <thomas.pundt@rp-online.de> ---- http://rp-online.de/ ----

В списке pgsql-admin по дате отправления:

Предыдущее
От: Bellur Ashwin
Дата:
Сообщение: Re: xlog related error
Следующее
От: sufian khan
Дата:
Сообщение: information about postgresql