From wgalafassijr@yahoo.com.br Wed Aug  6 13:50:25 2003
X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 9F30DD1C48E
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Aug 2003 13:50:25 +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 32159-08
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Aug 2003 10:49:07 -0300 (ADT)
Received: from smtp011.mail.yahoo.com (smtp011.mail.yahoo.com
 [216.136.173.31])
	by svr1.postgresql.org (Postfix) with SMTP id 3865ED1C4C1
	for <pgsql-general@postgresql.org>;
	Wed,  6 Aug 2003 10:50:14 -0300 (ADT)
Received: from unknown (HELO notebook) (wgalafassijr@200.180.192.112 with
	login)
	by smtp.mail.vip.sc5.yahoo.com with SMTP; 6 Aug 2003 13:50:17 -0000
Message-ID: <009d01c35c21$ba3a1270$70c0b4c8@notebook>
From: "Wilson A. Galafassi Jr." <wgalafassijr@yahoo.com.br>
To: <pgsql-sql@postgresql.org>
Subject: Postgresql slow on XEON 2.4ghz/1gb ram
Date: Wed, 6 Aug 2003 10:50:38 -0300
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_009A_01C35C08.92ACD580"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0 tests=HTML_30_40
X-Spam-Level: 
X-Archive-Number: 200308/287
X-Sequence-Number: 46704

This is a multi-part message in MIME format.

------=_NextPart_000_009A_01C35C08.92ACD580
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello.
I have this problem: i'm running the postgre 7.3 on a windows 2000 server w=
ith  P3 1GHZ DUAL/1gb ram with good performance. For best performance i hav=
e change the server for a  XEON 2.4/1gb ram and for  my suprise the perform=
ance decrease 80%. anybody have a similar experience? does exist any specia=
l configuration to postgre running on a Xeon processor? Any have any idea t=
o help-me? Excuse-me my bad english.
Very Thanks
Wilson
icq 77032308
msn wgalafassijr@hotmail.com

------=_NextPart_000_009A_01C35C08.92ACD580
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2>Hello.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I have this problem:&nbsp;i'm running&nbsp=
;the=20
postgre 7.3&nbsp;on a&nbsp;windows 2000 server&nbsp;with &nbsp;P3 1GHZ DUAL=
/1gb=20
ram&nbsp;with&nbsp;good performance.&nbsp;For best&nbsp;performance&nbsp;i =
have=20
change the server for a &nbsp;XEON 2.4/1gb ram and&nbsp;for&nbsp;&nbsp;my=
=20
suprise&nbsp;the performance decrease 80%.&nbsp;anybody have a similar=20
experience?&nbsp;does exist any&nbsp;special configuration to postgre runni=
ng on=20
a Xeon&nbsp;processor? Any have any idea to help-me? Excuse-me my bad=20
english.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Very Thanks</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Wilson</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>icq 77032308</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>msn=20
wgalafassijr@hotmail.com</FONT></DIV></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_009A_01C35C08.92ACD580--




From mlikharev@aurigin.com Wed Aug  6 22:04:51 2003
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 D557AD1C916
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Aug 2003 22:04:51 +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 86307-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Aug 2003 19:03:31 -0300 (ADT)
Received: from mailc03.aurigin.com (unknown [65.198.28.12])
	by svr1.postgresql.org (Postfix) with ESMTP id 9F913D1C914
	for <pgsql-sql@postgresql.org>; Wed,  6 Aug 2003 19:04:36 -0300 (ADT)
X-MimeOLE: Produced By Microsoft Exchange V6.0.4418.65
content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: Re: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram
Date: Wed, 6 Aug 2003 15:04:38 -0700
Message-ID: <56510AAEF435D240958D1CE8C6B1770A014A0EDD@mailc03.aurigin.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram
Thread-Index: AcNcSjZY69w3pWwcRWeGKn7nzKyiOQAHHDJg
From: "Maksim Likharev" <mlikharev@aurigin.com>
To: "Wilson A. Galafassi Jr." <wgalafassijr@yahoo.com.br>,
	<pgsql-sql@postgresql.org>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/61
X-Sequence-Number: 14677

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
=20




From kleptog@svana.org Thu Aug  7 09:30:18 2003
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 71DA9D1C4E1
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  7 Aug 2003 09:30:18 +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 50508-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  7 Aug 2003 06:28:56 -0300 (ADT)
Received: from svana.org (svana.org [203.20.62.76])
	by svr1.postgresql.org (Postfix) with ESMTP id 2BFAFD1C4BD
	for <pgsql-sql@postgresql.org>; Thu,  7 Aug 2003 06:30:07 -0300 (ADT)
Received: from kleptog by svana.org with local (Exim 3.35 #1 (Debian))
	id 19kh5z-00054d-00; Thu, 07 Aug 2003 19:30:07 +1000
Date: Thu, 7 Aug 2003 19:30:07 +1000
From: Martijn van Oosterhout <kleptog@svana.org>
To: "Wilson A. Galafassi Jr." <wgalafassijr@yahoo.com.br>
Cc: pgsql-sql@postgresql.org
Subject: Re: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram
Message-ID: <20030807093006.GA19280@svana.org>
Reply-To: Martijn van Oosterhout <kleptog@svana.org>
References: <009d01c35c21$ba3a1270$70c0b4c8@notebook>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="EVF5PPMfhYS0aIcm"
Content-Disposition: inline
In-Reply-To: <009d01c35c21$ba3a1270$70c0b4c8@notebook>
User-Agent: Mutt/1.3.28i
X-PGP-Key-ID: Length=1024; ID=0x0DC67BE6
X-PGP-Key-Fingerprint: 295F A899 A81A 156D B522  48A7 6394 F08A 0DC6 7BE6
X-PGP-Key-URL: <http://svana.org/kleptog/0DC67BE6.pgp.asc>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/64
X-Sequence-Number: 14680

--EVF5PPMfhYS0aIcm
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Wed, Aug 06, 2003 at 10:50:38AM -0300, Wilson A. Galafassi Jr. wrote:
> 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.

I assume you've done the vacuums, analyze, configured the wal and shmem
option appropriate for that size machine.

But in any case, without specific examples about what you're seeing we can't
help you.

--=20
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people pay for not being interested in politics is to be
> governed by people worse than themselves." - Plato

--EVF5PPMfhYS0aIcm
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE/MhweY5Twig3Ge+YRAgW0AJ0W2btR+4tPSCwn/S7ShvUUkPKkdQCdHuxY
xi5GBlEAGk8Sji9hPb8/dcc=
=GA98
-----END PGP SIGNATURE-----

--EVF5PPMfhYS0aIcm--



From xzilla@users.sourceforge.net Thu Aug  7 15:44:08 2003
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 <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	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 <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	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 <pgsql-sql@postgresql.org>; 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 <xzilla@users.sourceforge.net>
To: Maksim Likharev <mlikharev@aurigin.com>
Cc: "Wilson A. Galafassi Jr." <wgalafassijr@yahoo.com.br>,
	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