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@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/