Re: Need to find out which process is hitting hda - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Need to find out which process is hitting hda
Date
Msg-id dcc563d10712161555tb9974c6v420570ae4c1ac47b@mail.gmail.com
Whole thread Raw
In response to Re: Need to find out which process is hitting hda  (Ow Mun Heng <Ow.Mun.Heng@wdc.com>)
Responses Re: Need to find out which process is hitting hda
List pgsql-general
On Dec 14, 2007 1:33 AM, Ow Mun Heng <Ow.Mun.Heng@wdc.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.

pgsql-general by date:

Previous
From: Colin Wetherbee
Date:
Subject: Re: Efficiency vs. code bloat for SELECT wrappers
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Need to find out which process is hitting hda