X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 12970D1B4DA
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 13 Feb 2004 02:53:31 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 10904-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 12 Feb 2004 22:53:30 -0400 (AST)
Received: from tht.net (vista.tht.net [216.126.88.2])
	by svr1.postgresql.org (Postfix) with ESMTP id F2F1BD1B4BE
	for <pgsql-sql@postgresql.org>; Thu, 12 Feb 2004 22:53:25 -0400 (AST)
Received: from [134.22.71.153] (dyn-71-153.tor.dsl.tht.net [134.22.71.153])
	by tht.net (Postfix) with ESMTP
	id 6540A76B07; Thu, 12 Feb 2004 21:53:35 -0500 (EST)
Subject: Re: 7.4 - FK constraint performance
From: Rod Taylor <rbt@rbt.ca>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: ow <oneway_111@yahoo.com>, pgsql-sql@postgresql.org
In-Reply-To: <25808.1076634636@sss.pgh.pa.us>
References: <20040213010341.95282.qmail@web60801.mail.yahoo.com>
	<25808.1076634636@sss.pgh.pa.us>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-Sm/Nk84uafeokC0Om5Ks"
Message-Id: <1076640825.10896.12.camel@jester>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.5 
Date: Thu, 12 Feb 2004 21:53:45 -0500
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200402/158
X-Sequence-Number: 16849

--=-Sm/Nk84uafeokC0Om5Ks
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

On Thu, 2004-02-12 at 20:10, Tom Lane wrote:
> ow <oneway_111@yahoo.com> writes:
> > Sounds pretty bad for my case. Any way to avoid the 10% scan?
>=20
> Can't see how we optimize your case without pessimizing more-common cases.
> Sorry.

Statistics say there are 10 values. Statistics list the 10 most common
values (all of them). Given this, would it not be reasonable to assume
that 239 is a recent addition (if there at all) to the table and not
very common?

--=20
Rod Taylor <rbt [at] rbt [dot] ca>

Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
PGP Key: http://www.rbt.ca/rbtpub.asc

--=-Sm/Nk84uafeokC0Om5Ks
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (FreeBSD)

iD8DBQBALDw46DETLow6vwwRAh/TAJwN7mPHV7gw+SSyNvAys5Yp0/SvAwCfT/tw
RGgwr0plIk8PGNWaCHu8T2o=
=IBl+
-----END PGP SIGNATURE-----

--=-Sm/Nk84uafeokC0Om5Ks--