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 <[EMAIL PROTECTED]> http://www.jefftrout.com/ http://www.stuarthamm.net/
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
