Message-ID: <428420A1.9090707@arbash-meinel.com>
Date: Thu, 12 May 2005 22:36:01 -0500
From: John A Meinel <john@arbash-meinel.com>
User-Agent: Mozilla Thunderbird 1.0.2-1.3.2 (X11/20050324)
MIME-Version: 1.0
To: Sebastian Hennebrueder <usenet@laliluna.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: Recommendations for set statistics
References: <428416D8.8060303@laliluna.de>
In-Reply-To: <428416D8.8060303@laliluna.de>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="------------enig503BE9990A3B7576AFF93DA5"

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enig503BE9990A3B7576AFF93DA5
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit

Sebastian Hennebrueder wrote:
> Hello,
>
> I could not find any recommandations for the level of set statistics and
> what a specific level does actually mean.
> What is the difference between 1, 50 and 100? What is recommanded for a
> table or column?
>

Default I believe is 10. The higher the number, the more statistics are
kept, with a maximum of 1000.

The default is a little bit low for columns used in foreign keys, though
frequently it is okay.
When problems start, try setting them to 100 or 200. Higher is more
accurate, but takes longer to compute, *and* takes longer when planning
the optimal query method. It can be worth it, though.

John
=:->

--------------enig503BE9990A3B7576AFF93DA5
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFChCClJdeBCYSNAAMRAi8XAJ9G0bvNzT98YSjoJYv7RmYFCOD0mQCfXZdd
mL5e8q9Sjm+TwzCSOqUyY0E=
=W1Mu
-----END PGP SIGNATURE-----

--------------enig503BE9990A3B7576AFF93DA5--