Re: vacuum locking

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: vacuum locking
Дата
Msg-id 29064.1066915061@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: vacuum locking  (Andrew Sullivan <andrew@libertyrms.info>)
Ответы Re: vacuum locking  (Andrew Sullivan <andrew@libertyrms.info>)
Список pgsql-performance
Andrew Sullivan <andrew@libertyrms.info> writes:
> On Wed, Oct 22, 2003 at 09:27:47PM -0400, Tom Lane wrote:
>> trace.  What is causing that?  Not VACUUM I don't think.  It doesn't have
>> any huge memory demand.  But swapping out processes could account for

> What about if you've set vacuum_mem too high?

Maybe, but only if it actually had reason to use a ton of memory ---
that is, it were recycling a very large number of tuples in a single
table.  IIRC that didn't seem to be the case here.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: vacuum locking
Следующее
От: Allen Landsidel
Дата:
Сообщение: My own performance/tuning q&a