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