| From: | Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com> |
|---|---|
| To: | Gregory Stark <stark(at)enterprisedb(dot)com> |
| Cc: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, pgsql-hackers(at)postgresql(dot)org, "Decibel!" <decibel(at)decibel(dot)org>, Josh Berkus <josh(at)agliodbs(dot)com> |
| Subject: | Re: Overhauling GUCS |
| Date: | 2008-06-10 18:39:08 |
| Message-ID: | 484ECA4C.20004@cheapcomplexdevices.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Gregory Stark wrote:
> "Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
>> ...default_statistics_target?"..."Uhh 10."
>
> Ah, but we only ever hear about the cases where it's wrong of course. In other
> words even if we raised it to some optimal value we would still have precisely
> the same experience of seeing only posts on list about it being insufficient.
Yet if it was raised above the optimal, wouldn't you expect to hear cases
where it was too high?
It seems a slow painful way of finding a good setting might be to
keep increasing it until we had cases where the lists start telling
people they need to lower the parameter?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nathan Boley | 2008-06-10 18:46:02 | Re: Proposal - improve eqsel estimates by including histogram bucket numdistinct statistics |
| Previous Message | Jeff Davis | 2008-06-10 18:32:40 | Re: Proposal - improve eqsel estimates by including histogram bucket numdistinct statistics |