Re: Problems with autovacuum

From: Alvaro Herrera
Subject: Re: Problems with autovacuum
Date: ,
Msg-id: 20090526231242.GN32650@alvh.no-ip.org
(view: Whole thread, Raw)
In response to: Re: Problems with autovacuum  (Tom Lane)
Responses: Re: Problems with autovacuum  (Tom Lane)
List: pgsql-performance

Tree view

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 by date:

From: Erik Aronesty
Date:
Subject: Re: Hosted servers with good DB disk performance?
From: Alex Adriaanse
Date:
Subject: Re: Hosted servers with good DB disk performance?