Re: autovacuum fringe case?

От: Alvaro Herrera
Тема: Re: autovacuum fringe case?
Дата: ,
Msg-id: 20130124020304.GJ4249@alvh.no-ip.org
(см: обсуждение, исходный текст)
Ответ на: Re: autovacuum fringe case?  (AJ Weber)
Список: pgsql-performance

Скрыть дерево обсуждения

Two Necessary Kernel Tweaks for Linux Systems  (Shaun Thomas, )
 Re: Two Necessary Kernel Tweaks for Linux Systems  (Richard Neill, )
 Re: Two Necessary Kernel Tweaks for Linux Systems  (Merlin Moncure, )
 Re: Two Necessary Kernel Tweaks for Linux Systems  (Andrea Suisani, )
  Re: Two Necessary Kernel Tweaks for Linux Systems  (Andrea Suisani, )
 Re: Two Necessary Kernel Tweaks for Linux Systems  ("Midge Brown", )
  Re: Two Necessary Kernel Tweaks for Linux Systems  (Shaun Thomas, )
   Re: Two Necessary Kernel Tweaks for Linux Systems  (Scott Marlowe, )
    Re: Two Necessary Kernel Tweaks for Linux Systems  (Shaun Thomas, )
     Re: Two Necessary Kernel Tweaks for Linux Systems  (Scott Marlowe, )
      Re: Two Necessary Kernel Tweaks for Linux Systems  (Shaun Thomas, )
       Re: Two Necessary Kernel Tweaks for Linux Systems  (AJ Weber, )
        Re: Two Necessary Kernel Tweaks for Linux Systems  (Shaun Thomas, )
         Re: Two Necessary Kernel Tweaks for Linux Systems  (Alan Hodgson, )
         Re: Two Necessary Kernel Tweaks for Linux Systems  (Boszormenyi Zoltan, )
       Re: Two Necessary Kernel Tweaks for Linux Systems  (Henri Philipps, )
        Re: Two Necessary Kernel Tweaks for Linux Systems  (Shaun Thomas, )
        autovacuum fringe case?  (AJ Weber, )
         Re: autovacuum fringe case?  (Evgeniy Shishkin, )
         Re: autovacuum fringe case?  (Jeff Janes, )
          Re: autovacuum fringe case?  (AJ Weber, )
           Re: autovacuum fringe case?  (Alvaro Herrera, )
           Re: autovacuum fringe case?  (Jeff Janes, )
         Re: autovacuum fringe case?  ("Kevin Grittner", )

AJ Weber escribió:

> On 1/23/2013 2:13 PM, Jeff Janes wrote:

> >Scheduling a manual vacuum should be fine (but keep in mind that
> >vacuum has very different default cost_delay settings than autovacuum
> >does.  If the server is completely idle that shouldn't matter, but if
> >it is only mostly idle, you might want to throttle the IO a bit).  But
> >I certainly would not disable autovacuum without further evidence.  If
> >a table only needs to be vacuumed once a day and you preemptively do
> >it at 3a.m., then autovac won't bother to do it itself during the day.
> >  So there is no point, but much risk, in also turning autovac off.
> If I set autovacuum_max_workers = 1, will that effectively
> single-thread it so I don't have two running at once?  Maybe that'll
> mitigate disk contention a little at least?

If you have a single one, it will go three times as fast.  If you want
to make the whole thing go slower (i.e. cause less impact on your I/O
system when running), crank up autovacuum_vacuum_cost_delay.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



В списке pgsql-performance по дате сообщения:

От: Jeff Janes
Дата:
Сообщение: Re: autovacuum fringe case?
От: "Sachin D. Kotwal"
Дата:
Сообщение: DML's to tpcw benchmark for postgresql