Alan Stange wrote:
>
> Note that files in /tmp are usually in a tmpfs file system. These
> files may be the usage of swap that you're seeing (as they will be paged
> out on an active system with some memory pressure)
You can do a couple things with /tmp. Create a separate file system
for it so it will have zero impact on swap and use the "noatime" mount
option. Alternatively, limit the size of /tmp using the mount option
"size=MBm" replacing "MB" with the size you want it to be in MBytes. If
your application uses /tmp heavily, be sure to put it on a speedy,
local LUN.
> Finally, just as everyone suggests upgrading to newer postgresql
> releases, you probably want to get to a newer Solaris release.
If you really want to avoid swapping I'd suggest tuning your database
first with swap turned off and put it under a "normal" load while
watching both top and vmstat. When you're happy with it, turn swap
back on for those "heavy" load times and move on.
Greg
--
Greg Spiegelberg
Product Development Manager
Cranel, Incorporated.
Phone: 614.318.4314
Fax: 614.431.8388
Email: gspiegelberg@cranel.com
Technology. Integrity. Focus.