Re: Swapping on Solaris

From: Jeff <threshar(at)torgo(dot)978(dot)org>
To: Kevin Schroeder <kschroeder(at)mirageworks(dot)com>
Cc: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Swapping on Solaris
Date: 2005-01-19 16:58:21
Message-ID: 53308814-6A3B-11D9-9D52-000D9366F0C4@torgo.978.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On Jan 19, 2005, at 10:42 AM, Alan Stange wrote:

> Kevin Schroeder wrote:
>
>> I take that back. There actually is some paging going on. I ran sar
>> -g 5 10 and when a request was made (totally about 10 DB queries) my
>> pgout/s jumped to 5.8 and my ppgout/s jumped to 121.8. pgfree/s also
>> jumped to 121.80.
>
> I'm fairly sure that the pi and po numbers include file IO in Solaris,
> because of the unified VM and file systems.

Curiously, what are your shared_buffers and sort_mem set too?
Perhaps they are too high?

--
Jeff Trout <jeff(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Alan Stange 2005-01-19 17:04:21 Re: Swapping on Solaris
Previous Message Kevin Schroeder 2005-01-19 15:53:58 Re: Swapping on Solaris