От: Jim C. Nasby
Тема: Re: Vacuum looping?
Дата: ,
Msg-id: 20070728163624.GI39272@nasby.net
(см: обсуждение, исходный текст)
Ответ на: Vacuum looping?  ("Steven Flatt")
Ответы: Re: Vacuum looping?  ("Steven Flatt")
Список: pgsql-performance

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

Vacuum looping?  ("Steven Flatt", )
 Re: Vacuum looping?  (Tom Lane, )
 Re: Vacuum looping?  ("Jim C. Nasby", )
  Re: Vacuum looping?  ("Steven Flatt", )
   Re: Vacuum looping?  (Decibel!, )

On Fri, Jul 27, 2007 at 05:32:11PM -0400, Steven Flatt wrote:
> weren't convinced was doing anything), then start a manual vacuum with a
> higher vacuum_cost_limit to get things cleaned up quicker.

What are your vacuum_cost_* settings? If you set those too aggressively
you'll be in big trouble.

The second pass on the vacuum means that maintenance_work_memory isn't
large enough.
--
Jim Nasby                                      
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

Вложения

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

От: Ragnar
Дата:
Сообщение: Re: RES: select on 1milion register = 6s
От: "Bruno Rodrigues Siqueira"
Дата:
Сообщение: RES: RES: select on 1milion register = 6s