Re: Revisiting default_statistics_target - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Revisiting default_statistics_target
Date
Msg-id 28612.1243017667@sss.pgh.pa.us
Whole thread Raw
In response to Re: Revisiting default_statistics_target  ("Greg Sabino Mullane" <greg@turnstep.com>)
Responses Re: Revisiting default_statistics_target  ("Andrew Dunstan" <andrew@dunslane.net>)
List pgsql-hackers
"Greg Sabino Mullane" <greg@turnstep.com> writes:
> No, the 10 to 100 was supported by years of people working in the
> field who routinely did that adjustment (and >100) and saw great
> gains. Also, as the one who originally started the push to 100, my
> original goal was to get it over the "magic 99" bump, at which the
> planner started acting very differently.

That particular issue is gone anyway.

I'm not in a big hurry to revert this change either, but I think
Jignesh's results are sufficient reason to take a closer look at
the decision.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Revisiting default_statistics_target
Next
From: "Andrew Dunstan"
Date:
Subject: Re: Revisiting default_statistics_target