Re: [BULK] Problems with vacuum!

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: [BULK] Problems with vacuum!
Date: 2004-06-11 15:03:48
Message-ID: 87pt8616i3.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Domenico Sgarbossa" <domenico(at)xtecnica(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Litao Wu 2004-06-11 15:11:48 Re: reindex and copy - deadlock?
Previous Message Domenico Sgarbossa 2004-06-11 14:53:22 Re: [BULK] Problems with vacuum!