Re: Problems with autovacuum

From: Alvaro Herrera
Subject: Re: Problems with autovacuum
Date: ,
Msg-id: 20090609154827.GC5938@alvh.no-ip.org
(view: Whole thread, Raw)
In response to: Re: Problems with autovacuum  (Tom Lane)
Responses: Re: Problems with autovacuum  (Alvaro Herrera)
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ó:

> Well, that code isn't even correct I think; you're not supposed to
> modify a GUC variable directly.  I think you should just silently
> use a naptime of at least X without changing the nominal GUC variable.
> And definitely without the WARNING --- that's nothing but log spam.

Glitches fixed in this version; will apply shortly to 8.3 and HEAD.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Attachment

pgsql-performance by date:

From: Tom Lane
Date:
Subject: Re: Problems with autovacuum
From: David Kerr
Date:
Subject: Looking for installations with a large number of concurrent users