Re: [BULK] Problems with vacuum!

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: [BULK] Problems with vacuum!
Дата
Msg-id 87pt8616i3.fsf@asmodeus.mcnaught.org
обсуждение исходный текст
Ответ на Re: [BULK] Problems with vacuum!  ("Domenico Sgarbossa" <domenico@xtecnica.com>)
Ответы Re: [BULK] Problems with vacuum!
Список pgsql-performance
"Domenico Sgarbossa" <domenico@xtecnica.com> writes:

> Thanks for your advice!
>
> It seems that the cached memory isn't released by the system... so the
> system begin to swap to disk!

If you really think this is true, there should be a process that is
holding on to the memory.  Use 'ps' to find that process.

I also noticed that your shared_buffers setting seemed a bit low--you
might want to increase it.

-Doug

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

Предыдущее
От: "Domenico Sgarbossa"
Дата:
Сообщение: Re: [BULK] Problems with vacuum!
Следующее
От: Litao Wu
Дата:
Сообщение: Re: reindex and copy - deadlock?