>> I think the tests you could consider next is to graph the target going from
>> 10 to 100 in steps of 10 just for those 5 queries. If it gradually
>> degrades, that's interesting but hard to nail down. But if there's a sharp
>> transition, getting an explain plan for the two sides of that should provide
>> some insight. I'm really more interested in the ones that slowed down than
>> the one that improved, understanding that might finally provide some
>> evidence against increasing it by default.
>
> I've updated the charts to include results from setting
> default_statistics_target from 20-90. The links to the charts are the
> same. The links to the raw data are in
> http://207.173.203.223/~markwkm/community6/dbt3/ in directories 45-52.
I still think we're missing the boat here because it's not really the
same query every time.
...Robert