On Wed, May 17, 2006 at 10:29:14PM -0400, Tom Lane wrote: > The reason the default is currently 10 is just conservatism: it was > already an order of magnitude better than what it replaced (a *single* > representative value) and I didn't feel I had the evidence to justify > higher values. It's become clear that the default ought to be higher, > but I've still got no good fix on a more reasonable default. 100 might > be too much, or then again maybe not. > > I encourage you to play around with default_statistics_target and see > what you can learn about quality of estimates vs. planning time. Is the only downside to a large value planning speed? It seems it would be hard to bloat that too much, except in cases where people are striving for millisecond response times, and those folks had better know enough about tuning to be able to adjust the stats target... I'd wager that upping the target to 100 would eliminate a lot more support emails than it creates. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
