Re: [BULK] Problems with vacuum! - Mailing list pgsql-performance

From Doug McNaught
Subject Re: [BULK] Problems with vacuum!
Date
Msg-id 87pt8616i3.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Re: [BULK] Problems with vacuum!  ("Domenico Sgarbossa" <domenico@xtecnica.com>)
Responses Re: [BULK] Problems with vacuum!  (Dawn Hollingsworth <dmh@airdefense.net>)
List 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 by date:

Previous
From: "Domenico Sgarbossa"
Date:
Subject: Re: [BULK] Problems with vacuum!
Next
From: Litao Wu
Date:
Subject: Re: reindex and copy - deadlock?