Skip site navigation (1) Skip section navigation (2)

Re: [BULK] Problems with vacuum!

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 (view raw or flat)
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: jd.vcf
Description: text/x-vcard (640 bytes)

In response to

Responses

pgsql-performance by date

Next:From: Scott MarloweDate: 2004-06-18 18:58:27
Subject: Re: [BULK] Problems with vacuum!
Previous:From: Stephen FrostDate: 2004-06-18 18:16:03
Subject: Re: Major differences between oracle and postgres performance - what can I do ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group