; "Domenico Sgarbossa"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, June 18, 2004 8:58 PM
Subject: Re: [PERFORM] [BULK] Problems with vacuum!
> I believe it was more like the kernel was tuned to make it less common,
> but certain things can still trigger it. I kn
Hello,
I would have to double check BUT I believe this is fixed in later 2.4.x
kernels as well. If you don't want to go through the hassle of 2.6
(although it really is a nice kernel) then upgrade to 2.4.26.
Sincerely,
Joshau D. Drake
Scott Marlowe wrote:
On Fri, 2004-06-18 at 09:11, Tom Lane wr
I believe it was more like the kernel was tuned to make it less common,
but certain things can still trigger it. I know the problem was still
there in the 2.4.24 on the last server I was playing with, but it was a
lot less of a problem than it had been under 2.4.9 on an earlier machine
with the sa
On Fri, 2004-06-18 at 09:11, Tom Lane wrote:
> "Domenico Sgarbossa" <[EMAIL PROTECTED]> writes:
> > so when the users go home, i've got something like 15/2kb free ram, the
> > rest is cached and 0kb of swap...
> > It seems that when pg_dump starts the cached memory isn't released so the
> > sys
"Domenico Sgarbossa" <[EMAIL PROTECTED]> writes:
> so when the users go home, i've got something like 15/2kb free ram, the
> rest is cached and 0kb of swap...
> It seems that when pg_dump starts the cached memory isn't released so the
> system begin to swap,
A sane kernel should drop disk buff
The problems still remains...
I've tried to change shmax to 128 mb (i've got 2 GB of ram),
then the others parameter are set as follow:
shared_buffers = 8096# 2*max_connections, min 16
max_fsm_relations = 500# min 10, fsm is free space map
max_fsm_pages = 15000 # min 1000, fsm is
We actually found that in the 2.4-20 kernel for RedHat there was a known
issue that was causing cached memory to not be reused and our box
started to swap also.
http://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=89226
This may be what you are experiencing if your using the same kernel.
Dawn H
"Domenico Sgarbossa" <[EMAIL PROTECTED]> 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 tha
