<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html style="direction: ltr;">
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<style>body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="UTF-8" bgcolor="#ffffff"
text="#000000">
<br>
<blockquote
cite="mid:CAP=oouE75E_6fc7oA87tdqp_jyCeAfjaQEy+hM=MJ8EwfPdVdQ(at)mail(dot)gmail(dot)com"
type="cite">
<pre wrap="">Yes, a few hundred MB of swap, and its definitely making a huge
difference. Upon restarting postgres, its all freed up, and then perf
is good again. Also, this box only has 1GB of swap total, so its
never going to get up a few dozen GB.
Anyway, here's some of top output for systemA right now:</pre>
</blockquote>
Instead of restarting the database try swapoff -a && swapon
-a and see if that helps performance. If it is that little swap in
use, it might be something else clogging up the works.<br>
<br>
Sim<br>
</body>
</html>