| From: | markw(at)osdl(dot)org |
|---|---|
| To: | tgl(at)sss(dot)pgh(dot)pa(dot)us |
| Cc: | neilc(at)samurai(dot)com, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: raising the default default_statistics_target |
| Date: | 2004-03-08 18:46:36 |
| Message-ID: | 200403081846.i28IkkE20108@mail.osdl.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 7 Mar, Tom Lane wrote:
> Neil Conway <neilc(at)samurai(dot)com> writes:
>> Tom Lane wrote:
>>> This is something we need to consider, but we'll need more evidence
>>> before making a choice. One thing that we have very little data about
>>> is how much difference it makes in the quality of planner choices.
>
>> Right, but is there a practical way to actually get this data?
>
> I haven't thought of one yet, but perhaps someone will have an idea.
If DBT-3 is an appropriate test, we can get those EXPLAIN ANALYZE
changes I have working in the STP version and queued up tests varying
the default_statistics_target parameter.
Mark
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2004-03-08 19:07:12 | Re: raising the default default_statistics_target |
| Previous Message | Tom Lane | 2004-03-08 18:37:53 | Re: raising the default default_statistics_target |