Re: Need to find out which process is hitting hda

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Ow Mun Heng" <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Merlin Moncure" <mmoncure(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Need to find out which process is hitting hda
Date: 2007-12-16 23:55:55
Message-ID: dcc563d10712161555tb9974c6v420570ae4c1ac47b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Dec 14, 2007 1:33 AM, Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> wrote:
> I kept looking at the io columns and didn't even think of the swap
> partition. It's true that it's moving quite erratically but I won't say
> that it's really thrashing.
>
> total used free shared buffers cached
> Mem: 503 498 4 0 3 287
> -/+ buffers/cache: 207 295
> Swap: 2527 328 2199
>
> (YEP, I know I'm RAM starved on this machine)

Good lord, my laptop has more memory than that. :)

What Tom said, buy some more RAM. Also, look at turning down the
swappiness setting as well.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2007-12-17 00:11:07 Re: Need to find out which process is hitting hda
Previous Message Colin Wetherbee 2007-12-16 23:49:05 Re: Efficiency vs. code bloat for SELECT wrappers