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 ; 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 ; 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 ; 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." To: 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
Hello.
I have this problem: i'm running = ;the=20 postgre 7.3 on a windows 2000 server with  P3 1GHZ DUAL= /1gb=20 ram with good performance. For best performance i = have=20 change the server for a  XEON 2.4/1gb ram and for  my= =20 suprise the performance decrease 80%. anybody have a similar=20 experience? does exist any special configuration to postgre runni= ng on=20 a Xeon processor? Any have any idea to help-me? Excuse-me my bad=20 english.
Very Thanks
Wilson
icq 77032308
msn=20 wgalafassijr@hotmail.com
 
------=_NextPart_000_009A_01C35C08.92ACD580-- 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 ; 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 ; 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 ; 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 To: "Wilson A. Galafassi Jr." 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 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: 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 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--