"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> I'm not sure I want to vote for another 10x increase by
>> default, though.
> Outside of longer analyze times, and slightly more space taken up by the
> statistics, what is the downside?
Longer plan times --- several of the selfuncs.c routines grovel over all
the entries in the pg_statistic row. AFAIK no one's measured the real
impact of that, but it could easily be counterproductive for simple queries.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
