Re: Revisiting default_statistics_target

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Revisiting default_statistics_target
Date: 2009-05-22 18:41:07
Message-ID: 28612.1243017667@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Greg Sabino Mullane" <greg(at)turnstep(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2009-05-22 18:50:55 Re: Revisiting default_statistics_target
Previous Message Tom Lane 2009-05-22 18:38:20 Re: Revisiting default_statistics_target