Re: Problems with autovacuum

Список
Период
Сортировка
От Tom Lane
Тема Re: Problems with autovacuum
Дата
Msg-id 16822.1243364479@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Problems with autovacuum  (Alvaro Herrera)
Ответы Re: Problems with autovacuum  (Alvaro Herrera)
Список 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:
> Sorry, it's the other way around actually -- correct for 8.3 onwards,
> wrong for 8.1 and 8.2.  In the earlier versions, it would do one run in
> a chosen database, sleep during "naptime", then do another run.

> Tom Lane escribió:
>> 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?)

> The word "minimum" is there because it's possible that all workers are
> busy with some other database(s).

>> Please improve the docs.

> I'll see about that.

Hmm, maybe we need to improve the code too.  This example suggests that
there needs to be some limit on the worker launch rate, even if there
are so many databases that that means we don't meet naptime exactly.

            regards, tom lane

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

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