Re: Problems with autovacuum

Список
Период
Сортировка
От Tom Lane
Тема Re: Problems with autovacuum
Дата
Msg-id 16350.1243362502@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Problems with autovacuum  (Alvaro Herrera)
Ответы Re: Problems with autovacuum  (Alvaro Herrera)
Re: Problems with autovacuum  (Łukasz Jagiełło)
Список pgsql-performance
Дерево обсуждения
Problems with autovacuum  (Łukasz Jagiełło, )
 Re: Problems with autovacuum  (Scott Marlowe, )
  Re: Problems with autovacuum  (Grzegorz Jaśkiewicz, )
   Re: Problems with autovacuum  (Scott Marlowe, )
   Re: Problems with autovacuum  (Łukasz Jagiełło, )
    Re: Problems with autovacuum  (Tom Lane, )
     Re: Problems with autovacuum  (Łukasz Jagiełło, )
     Re: Problems with autovacuum  (Alvaro Herrera, )
      Re: Problems with autovacuum  (Tom Lane, )
       Re: Problems with autovacuum  (Alvaro Herrera, )
        Re: Problems with autovacuum  (Tom Lane, )
         Re: Problems with autovacuum  (Alvaro Herrera, )
          Re: Problems with autovacuum  (Tom Lane, )
           Re: Problems with autovacuum  (Alvaro Herrera, )
            Re: Problems with autovacuum  (Tom Lane, )
             Re: Problems with autovacuum  (Scott Marlowe, )
             Re: Problems with autovacuum  (Alvaro Herrera, )
              Re: Problems with autovacuum  (Tom Lane, )
               Re: Problems with autovacuum  (Alvaro Herrera, )
                Re: Problems with autovacuum  (Alvaro Herrera, )
                Re: Problems with autovacuum  (Tom Lane, )
       Re: Problems with autovacuum  (Łukasz Jagiełło, )
  Re: Problems with autovacuum  (Łukasz Jagiełło, )
   Re: Problems with autovacuum  (Grzegorz Jaśkiewicz, )
Alvaro Herrera <> writes:
> Tom Lane escribi�:
>> I believe the interpretation of autovacuum_naptime is that it should
>> examine each database that often, ie once a minute by default.  So
>> it's got more than 30 databases per second to look through.

> Note that this is correct in 8.1 and 8.2 but not 8.3 onwards.

Oh?  The current documentation still defines the variable thusly:

    Specifies the minimum delay between autovacuum runs on any given
    database. In each round the daemon examines the database and
    issues VACUUM and ANALYZE commands as needed for tables in that
    database.

I suppose the use of "minimum" means that this is not technically
incorrect, but it's sure not very helpful if there is some other
rule involved that causes it to not behave as I said.  (And if there
is some other rule, what is that?)  Please improve the docs.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Problems with autovacuum
Следующее
От: Greg Smith
Дата:
Сообщение: Re: Hosted servers with good DB disk performance?