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" <[EMAIL PROTECTED]> 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 - [EMAIL PROTECTED] - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
fn:Joshua D. Drake
n:Drake;Joshua D.
org:Command Prompt, Inc.
adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA
email;internet:[EMAIL PROTECTED]
note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We  provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored  the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to