On Dec 5, 2005, at 12:11 AM, James Dey wrote:
“Secondly "sar" is showing that you are dipping quite a bit into
your swap space. When dealing with a database server, any time
that you move from RAM to swap you will see a massive performance
drop, especially when dealing with as much swap as this machine
has. At its peak you were hitting 70%(700M) of swap. Since
PostgreSQL is unsupported I don't have any suggestions on query
optimizations. However, at this point upgrading your available RAM
would be one of my best suggestions.”
Does anyone have any experience on this? Most of the things I have
read suggest that I move back to 32 bit but I do think it’s a step
backward – that’s if this can be supported.
Welcome to the list.
I don't have an answer for you but I'll suggest that you might have
better luck finding one on the performance list. Or even the general
list. Also there are archives for all lists which might also provide
John DeSoi, Ph.D.
Power Tools for PostgreSQL