From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Scott Marlowe <smarlowe(at)qwest(dot)net> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Domenico Sgarbossa <domenico(at)xtecnica(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: [BULK] Problems with vacuum! |
Date: | 2004-06-18 18:47:24 |
Message-ID: | 40D338BC.7080705@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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 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
Attachment | Content-Type | Size |
---|---|---|
jd.vcf | text/x-vcard | 640 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2004-06-18 18:58:27 | Re: [BULK] Problems with vacuum! |
Previous Message | Stephen Frost | 2004-06-18 18:16:03 | Re: Major differences between oracle and postgres performance - what can I do ? |