> This is normal. My personal workstation has been up for 16
> days, and it shows 65 megs used for swap. The linux kernel
> looks for things that haven't been accessed in quite a while
> and tosses them into swap to free up the memory for other uses.
> This isn't PostgreSQL's fault, or anything elses. It's how a
> typical Unix kernel works. I.e. you're seeing a problem that
> simply isn't there.
Actually it (and other OSes) does slightly better than that. It _copies_
the least recently used pages into swap, but leaves them in memory. Then
when there really is a need to swap stuff out there is no need to actually
write to swap because it's already been done, and conversely if those pages
are wanted then they don't have to be read from disk because they were never
removed from memory.
In response to
pgsql-performance by date
|Next:||From: Hervé Piedvache||Date: 2004-07-16 11:17:02|
|Subject: Re: Insert are going slower ...|
|Previous:||From: Mark Aufflick||Date: 2004-07-16 03:25:17|
|Subject: Re: hardware raid suggestions|