On Tue, 2012-12-11 at 17:07 +0000, Thomas Kaltofen wrote:
I leave the server running for several hours without touching the database at all (e.g. over the night).
Most servers (especially Unix/Linux/Solaris) schedule checks overnight that often visit every file on the system, and the consequence is that the server will be swapped out to disk.
Try leaving a cron job running that runs a simple query every hour...
Liam