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/
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 |