X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id F03EE9DCD7A for ; Mon, 5 Dec 2005 04:20:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 11997-06 for ; Mon, 5 Dec 2005 04:20:38 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by postgresql.org (Postfix) with ESMTP id 46E9A9DCCA2 for ; Mon, 5 Dec 2005 04:20:34 -0400 (AST) Received: from mail-01.jhb.wbs.co.za (mail-01.jhb.wbs.co.za [196.30.31.196]) by svr2.postgresql.org (Postfix) with ESMTP id 7B2B4F0CE0 for ; Mon, 5 Dec 2005 05:11:45 +0000 (GMT) Received: from wbs-196-2-118-207.wbs.co.za ([196.2.118.207] helo=James) by mail-01.jhb.wbs.co.za with esmtp (Exim 4.50) id 1Ej8dK-0004f4-4G for pgsql-php@postgresql.org; Mon, 05 Dec 2005 07:11:33 +0200 From: "James Dey" To: Subject: 64 Bit / Swap Issue? Date: Mon, 5 Dec 2005 07:11:25 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0010_01C5F96B.1B5FFEA0" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AcX5WkQ2BnERA2CrSlerWGvgFvXCiA== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Original-Subject: 64 Bit / Swap Issue? Message-Id: <20051205051145.7B2B4F0CE0@svr2.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.333 required=5 tests=[HTML_MESSAGE=0.001, RCVD_IN_BL_SPAMCOP_NET=1.332] X-Spam-Score: 1.333 X-Spam-Level: * X-Archive-Number: 200512/1 X-Sequence-Number: 3348 This is a multi-part message in MIME format. ------=_NextPart_000_0010_01C5F96B.1B5FFEA0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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@mygus.com 0861-11-44-03 Intl. : +27 (0) 11 704-1945 Fax : +27 (0) 11 3888-907 Mobile : +27 (0) 82-7855-102 ------=_NextPart_000_0010_01C5F96B.1B5FFEA0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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:

 

“Seco= ndly "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@mygus.com=

 

0861-11-44-03

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

Fax : +27 (0) = 11 3888-907

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

 

------=_NextPart_000_0010_01C5F96B.1B5FFEA0--