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.
Joshau D. Drake
Scott Marlowe wrote:
> On Fri, 2004-06-18 at 09:11, Tom Lane wrote:
>>"Domenico Sgarbossa" <domenico(at)xtecnica(dot)com> writes:
>>>so when the users go home, i've got something like 15/20000kb 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 buffers rather than swapping. We heard
>>recently about a bug in some versions of the Linux kernel that cause it
>>to prefer swapping to discarding disk cache, though. It sounds like
>>that's what you're hitting. Look into newer kernels ...
> This was a common problem in the linux 2.4 series kernels, but has
> supposedly been fixed in the 2.6 kernels. Having lots of memory and
> turning off swap will "fix" the problem in 2.4, but if you run out of
> real mem, you're hosed.
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
Description: text/x-vcard (640 bytes)
In response to
pgsql-performance by date
|Next:||From: Scott Marlowe||Date: 2004-06-18 18:58:27|
|Subject: Re: [BULK] Problems with vacuum!|
|Previous:||From: Stephen Frost||Date: 2004-06-18 18:16:03|
|Subject: Re: Major differences between oracle and postgres performance - what can I do ?|