От: Michael Stone
Тема: Re: Parallel Vacuum
Дата: ,
Msg-id: 20070322171007.GH11402@mathom.us
(см: обсуждение, исходный текст)
Ответ на: Re: Parallel Vacuum  (Dimitri)
Ответы: Re: Parallel Vacuum  (Dimitri)
Список: pgsql-performance

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

Parallel Vacuum  (Dimitri, )
 Re: Parallel Vacuum  (Alvaro Herrera, )
  Re: Parallel Vacuum  (Dimitri, )
   Re: Parallel Vacuum  (Alvaro Herrera, )
    Re: Parallel Vacuum  (Dimitri, )
     Re: Parallel Vacuum  (Alvaro Herrera, )
     Re: Parallel Vacuum  (Michael Stone, )
      Re: Parallel Vacuum  (Dimitri, )
       Re: Parallel Vacuum  (Michael Stone, )
        Re: Parallel Vacuum  (Dimitri, )
         Re: Parallel Vacuum  (Michael Stone, )

On Thu, Mar 22, 2007 at 04:55:02PM +0100, Dimitri wrote:
>In my case I have several CPU on the server and quite powerful storage box
>which is not really busy with a single vacuum. So, my idea is quite simple -
>speed-up vacuum with parallel execution (just an algorithm):

Vacuum is I/O intensive, not CPU intensive. Running more of them will
probably make things slower rather than faster, unless each thing you're
vacuuming has its own (separate) disks. The fact that your CPU isn't
pegged while vacuuming suggests that your disk is already your
bottleneck--and doing multiple sequential scans on the same disk will
definitely be slower than doing one.

Mike Stone


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

От: Tino Wildenhain
Дата:
Сообщение: Re: Performance of count(*)
От: Michael Stone
Дата:
Сообщение: Re: Performance of count(*)