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")
Ответы: Re: [BULK] Problems with vacuum!  (Dawn Hollingsworth)
Список: pgsql-performance

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

Re: [BULK] Problems with vacuum!  ("Domenico Sgarbossa", )
 Re: [BULK] Problems with vacuum!  (Doug McNaught, )
  Re: [BULK] Problems with vacuum!  (Dawn Hollingsworth, )
 Re: [BULK] Problems with vacuum!  ("Domenico Sgarbossa", )
  Re: [BULK] Problems with vacuum!  (Tom Lane, )
   Re: [BULK] Problems with vacuum!  ("Scott Marlowe", )
    Re: [BULK] Problems with vacuum!  ("Joshua D. Drake", )
 Re: [BULK] Problems with vacuum!  ("Scott Marlowe", )
 Re: [BULK] Problems with vacuum!  ("Domenico Sgarbossa", )

"Domenico Sgarbossa" <> 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 по дате сообщения:

От: Tom Lane
Дата:
Сообщение: Re: reindex and copy - deadlock?
От: "Merlin Moncure"
Дата:
Сообщение: Re: in-transaction insert performance in 7.5devel