64 Bit / Swap Issue?

From: "James Dey" <james(at)mygus(dot)com>
To: <pgsql-php(at)postgresql(dot)org>
Subject: 64 Bit / Swap Issue?
Date: 2005-12-05 05:11:25
Message-ID: 20051205051145.7B2B4F0CE0@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

Hi Guys,

We have been running our systems on high end Redhat ES 32 Bit servers
without any sort of glitch. We have now set up a 64 bit Athlon server
running Redhat ES, installed the Redhat PgSQL as well as the PHP5 RPM.

I have been experiencing incredible slow performance from my server, and am
at a loss for solution. Should I be moving back to a 32 bit system?

This is the reply I have from Rackspace:

"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.

Regards and thanks,

James Dey

james(at)mygus(dot)com

0861-11-44-03

Intl. : +27 (0) 11 704-1945

Fax : +27 (0) 11 3888-907

Mobile : +27 (0) 82-7855-102

Responses

Browse pgsql-php by date

  From Date Subject
Next Message John DeSoi 2005-12-05 16:14:30 Re: 64 Bit / Swap Issue?
Previous Message Michelle Konzack 2005-11-30 15:05:41 Re: Cancel my mail