Re: Problems with autovacuum

Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Problems with autovacuum
Дата
Msg-id 20090526231242.GN32650@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Problems with autovacuum  (Tom Lane)
Ответы Re: Problems with autovacuum  (Tom Lane)
Список 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, )
Tom Lane escribió:

> 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.

We already have a 100ms lower bound on the sleep time (see
launcher_determine_sleep()).  Maybe that needs to be increased?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

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

Предыдущее
От: Erik Aronesty
Дата:
Сообщение: Re: Hosted servers with good DB disk performance?
Следующее
От: Alex Adriaanse
Дата:
Сообщение: Re: Hosted servers with good DB disk performance?