Maximum statistics target - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Maximum statistics target
Date
Msg-id 200803071925.26532.peter_e@gmx.net
Whole thread Raw
Responses Re: Maximum statistics target
List pgsql-hackers
Related to the concurrent discussion about selectivity estimations ...

What is the reason the statistics target is limited to 1000?  I've seen more 
than one case where increasing the statistics target to 1000 improved results 
and one would have wanted to increase it further.

What's the problem with setting it to ten million if I have ten million values 
in the table and I am prepared to spend the resources to maintain those 
statistics?


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [COMMITTERS] pgsql: Add: > o Add SQLSTATE severity to PGconn return status > >
Next
From: Andrew Chernow
Date:
Subject: Re: Commitfest status