Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id ADE9B2E02FC
	for <pgsql-hackers-postgresql.org@postgresql.org>;
	Fri,  7 Mar 2008 14:42:18 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 68722-04 for
	<pgsql-hackers-postgresql.org@postgresql.org>;
	Fri,  7 Mar 2008 14:42:11 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from svana.org (svana.org [203.190.233.187])
	by postgresql.org (Postfix) with ESMTP id 4CC4F2E028C
	for <pgsql-hackers@postgresql.org>;
	Fri,  7 Mar 2008 14:42:13 -0400 (AST)
Received: from kleptog by svana.org with local (Exim 4.50)
	id 1JXhW1-0006Ek-DY; Sat, 08 Mar 2008 05:41:57 +1100
Date: Fri, 7 Mar 2008 19:41:57 +0100
From: Martijn van Oosterhout <kleptog@svana.org>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Maximum statistics target
Message-ID: <20080307184157.GA23644@svana.org>
Reply-To: Martijn van Oosterhout <kleptog@svana.org>
References: <200803071925.26532.peter_e@gmx.net>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="ZGiS0Q5IWpPtfppv"
Content-Disposition: inline
In-Reply-To: <200803071925.26532.peter_e@gmx.net>
X-PGP-Key-ID: Length=1024; ID=0x6F0B424C
X-PGP-Key-Fingerprint: 34A8 8EAC F902 8C8D CA72  DCC7 201E DB34 6F0B 424C
User-Agent: Mutt/1.5.9i
X-SA-Exim-Connect-IP: <locally generated>
X-SA-Exim-Mail-From: kleptog@svana.org
X-SA-Exim-Scanned: No (on svana.org); SAEximRunCond expanded to false
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200803/191
X-Sequence-Number: 114992


--ZGiS0Q5IWpPtfppv
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Fri, Mar 07, 2008 at 07:25:25PM +0100, Peter Eisentraut wrote:
> What's the problem with setting it to ten million if I have ten million v=
alues=20
> in the table and I am prepared to spend the resources to maintain those=
=20
> statistics?

That it'll probably take 10 million seconds to calculate the plans
using it? I think Tom pointed there are a few places that are O(n^2)
the number entries...

Have a nice day,
--=20
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while=20
> boarding. Thank you for flying nlogn airlines.

--ZGiS0Q5IWpPtfppv
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFH0Yx1IB7bNG8LQkwRAsqHAJ9O336fsbTTuIWPA8FVwSLedxzT6ACeNULD
aq87cxfB+Xl8m2aemQJc9j0=
=rAAb
-----END PGP SIGNATURE-----

--ZGiS0Q5IWpPtfppv--