Re: 64 Bit / Swap Issue?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Hi James,

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 some clues.

John DeSoi, Ph.D.
Power Tools for PostgreSQL

[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux