X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id E2B88D4D2F for ; Fri, 11 Jul 2003 18:35:12 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 67656-06 for ; Fri, 11 Jul 2003 15:35:01 -0300 (ADT) Received: from mailav.tor1.inquent.com (mail.inquent.com [216.208.117.106]) by svr1.postgresql.org (Postfix) with ESMTP id 3D804D16C6 for ; Fri, 11 Jul 2003 15:13:59 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mailav.tor1.inquent.com (Postfix) with ESMTP id B07BC1024D; Fri, 11 Jul 2003 14:07:30 -0400 (EDT) Received: from [10.0.2.7] (unknown [10.0.2.7]) by mailav.tor1.inquent.com (Postfix) with ESMTP id 4CAD810248; Fri, 11 Jul 2003 14:07:28 -0400 (EDT) Subject: Re: force the use of a particular index From: Rod Taylor To: Scott Cain Cc: Postgresql Performance In-Reply-To: <1057944059.5766.34.camel@localhost.localdomain> References: <1057850280.1451.22.camel@localhost.localdomain> <1057920672.46100.149.camel@jester> <1057929459.5766.7.camel@localhost.localdomain> <1057930695.46100.172.camel@jester> <1057937779.5767.17.camel@localhost.localdomain> <1057940450.65544.14.camel@jester> <1057944059.5766.34.camel@localhost.localdomain> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-MgIJz9eNr28YhK4WMPO7" Message-Id: <1057947284.65544.129.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.0 Date: 11 Jul 2003 14:14:45 -0400 X-Virus-Scanned: by AMaViS perl-11 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/179 X-Sequence-Number: 2472 --=-MgIJz9eNr28YhK4WMPO7 Content-Type: text/plain Content-Transfer-Encoding: quoted-printable > > set enable_hashjoin =3D false; >=20 > BINGO! I'm not so sure about that. Your dataset seems to have changed fairly significantly since the last test. > -> Index Scan using feature_pkey on feature f (cost=3D0.00..134592.43 r= ows=3D47912 width=3D39) (actual time=3D0.46..502.50 rows=3D431 loops=3D1) Notice it only pulled out 431 rows where prior runs pulled out several thousand (~13000). I think what really happened was something came along and deleted a bunch of stuff, then vacuum ran. --=-MgIJz9eNr28YhK4WMPO7 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/Dv6U6DETLow6vwwRAtvLAJ97871/AsF/HJHde8OkVt/M/eaxngCfcyGf HfR5rF9jKGm9vnv5b1ndlV0= =7hTh -----END PGP SIGNATURE----- --=-MgIJz9eNr28YhK4WMPO7--