>> 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
