X-Original-To: pgsql-performance@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id DC475924F68 for ; Tue, 20 May 2003 09:09:01 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 40397-02 for ; Tue, 20 May 2003 09:08:58 -0400 (EDT) Received: from tomts21-srv.bellnexxia.net (tomts21.bellnexxia.net [209.226.175.183]) by developer.postgresql.org (Postfix) with ESMTP id 6A1BA924F67 for ; Tue, 20 May 2003 09:08:57 -0400 (EDT) Received: from [10.0.2.7] ([216.208.117.7]) by tomts21-srv.bellnexxia.net (InterMail vM.5.01.05.32 201-253-122-126-132-20030307) with ESMTP id <20030520130855.BGPM2574.tomts21-srv.bellnexxia.net@[10.0.2.7]>; Tue, 20 May 2003 09:08:55 -0400 Subject: Re: 7.3.2 vs 7.1.2 From: Rod Taylor To: Eugene Fokin Cc: Postgresql Performance In-Reply-To: <20030520122838.GA28654@solvo.ru> References: <20030520122838.GA28654@solvo.ru> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-ll38YrWA8b2aqyQIhAcC" Organization: Message-Id: <1053436138.21079.1.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.4 Date: 20 May 2003 09:08:59 -0400 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/192 X-Sequence-Number: 1971 --=-ll38YrWA8b2aqyQIhAcC Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Tue, 2003-05-20 at 08:28, Eugene Fokin wrote: > Hello. > I'm just going to upgrade from 7.1.2 to 7.3.2 and found that some > of my queries performing on 7.3.2 much slower than on 7.1.2. This generally indicates misconfiguration of some kind or required tweaking. > P.S. Of course, I can show the query. Please show EXPLAIN ANALYZE output along with the query. --=20 Rod Taylor PGP Key: http://www.rbt.ca/rbtpub.asc --=-ll38YrWA8b2aqyQIhAcC Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (FreeBSD) iD8DBQA+yijq6DETLow6vwwRAtVZAJ94phAj19PKfQr3yAmgzCpr3MWDagCeLUt6 EI0CxGAOGIUH0ZQ2knrrYsc= =jxvg -----END PGP SIGNATURE----- --=-ll38YrWA8b2aqyQIhAcC--