Re: Better default_statistics_target - Mailing list pgsql-patches

From Tom Lane
Subject Re: Better default_statistics_target
Date
Msg-id 13872.1195016406@sss.pgh.pa.us
Whole thread Raw
In response to Better default_statistics_target  (Greg Sabino Mullane <greg@turnstep.com>)
Responses Re: Better default_statistics_target
List pgsql-patches
Greg Sabino Mullane <greg@turnstep.com> writes:
> Per a recent bug in which the planner can behave very differently at <
> 100, and accounting for the fact that analyze is still plenty fast on
> today's systems even at a tenfold increase, attached is a patch to
> change default_statistics_target from 10 to 100.

This is not happening without a whole lot more evidence (as in, more
than zero) to back up the choice of value.

            regards, tom lane

pgsql-patches by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Better default_statistics_target
Next
From: ITAGAKI Takahiro
Date:
Subject: Miscalculation in IsCheckpointOnSchedule()