X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 889A2D1C4ED for ; Thu, 7 Aug 2003 15:44:08 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 92876-09 for ; Thu, 7 Aug 2003 12:42:43 -0300 (ADT) Received: from localhost.localdomain (unknown [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id 738D3D1C4CA for ; Thu, 7 Aug 2003 12:43:57 -0300 (ADT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by localhost.localdomain (8.12.8/8.12.8) with ESMTP id h77EPKqd001726; Thu, 7 Aug 2003 10:25:21 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id h77FhgZ19197; Thu, 7 Aug 2003 11:43:43 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id 34AD3DN0; Thu, 7 Aug 2003 11:43:41 -0400 Subject: Re: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram From: Robert Treat To: Maksim Likharev Cc: "Wilson A. Galafassi Jr." , pgsql-sql@postgresql.org In-Reply-To: <56510AAEF435D240958D1CE8C6B1770A014A0EDD@mailc03.aurigin.com> References: <56510AAEF435D240958D1CE8C6B1770A014A0EDD@mailc03.aurigin.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 07 Aug 2003 11:43:42 -0400 Message-Id: <1060271022.22259.2137.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/66 X-Sequence-Number: 14682 If you went from a dual processor box running windows to a single processor box running windows, I wouldn't be surprised to see a slow down. I'd recommend switching from Windows to Linux/BSD over a hardware upgrade any day. Robert Treat On Wed, 2003-08-06 at 18:04, Maksim Likharev wrote: > What OS, if Linux what kernel > > -----Original Message----- > From: Wilson A. Galafassi Jr. [mailto:wgalafassijr@yahoo.com.br] > Sent: Wednesday, August 06, 2003 6:51 AM > To: pgsql-sql@postgresql.org > Subject: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram > > > > Hello. > I have this problem: i'm running the postgre 7.3 on a windows 2000 > server with P3 1GHZ DUAL/1gb ram with good performance. For best > performance i have change the server for a XEON 2.4/1gb ram and for my > suprise the performance decrease 80%. anybody have a similar experience? > does exist any special configuration to postgre running on a Xeon > processor? Any have any idea to help-me? Excuse-me my bad english. > Very Thanks > Wilson > icq 77032308 > msn wgalafassijr@hotmail.com -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL