pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <smarlowe@qwest.net>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Domenico Sgarbossa <domenico@xtecnica.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: [BULK] Problems with vacuum!
Date: Fri, 18 Jun 2004 12:58:27 -0600
Message-ID: <1087585107.28062.16.camel@localhost.localdomain> (raw)
In-Reply-To: <40D338BC.7080705@commandprompt.com>
References: <003c01c44fbd$c84a6af0$2500fa0a@CardServices.TCI.com>
	<004c01c44fc3$d7cdeaf0$70c8007e@xtecnica.it>
	<87pt8616i3.fsf@asmodeus.mcnaught.org>
	<1087226647.1775.14.camel@kaos>
	<011101c4553b$c1967130$70c8007e@xtecnica.it>
	<20554.1087571463@sss.pgh.pa.us>
	<1087582040.28062.13.camel@localhost.localdomain>
	<40D338BC.7080705@commandprompt.com>

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 same basic amount of memory.

On Fri, 2004-06-18 at 12:47, Joshua D. Drake wrote:
> 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@xtecnica.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
> 




view thread (11+ messages)  latest in thread

Message-ID: <1087585107.28062.16.camel@localhost.localdomain>
Permalink:  ../1087585107.28062.16.camel@localhost.localdomain/
Also on:    postgresql.org/message-id/1087585107.28062.16.camel@localhost.localdomain

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: smarlowe@qwest.net, jd@commandprompt.com, tgl@sss.pgh.pa.us, domenico@xtecnica.com
  Subject: Re: [BULK] Problems with vacuum!
  In-Reply-To: <1087585107.28062.16.camel@localhost.localdomain>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox