On Sun, Feb 12, 2006 at 06:29:21PM -0500, Andrew Dunstan wrote: > Frankly - supplying more sample configs is likely to be fairly > fruitless. A much better thing would be a really good tuning tool that > would take stats and logs and other stuff from a running server and > suggest improvements (e.g. add an index on fields (foo,bar) on baz, try > doubling work_mem, increase stats buckets on blurfl ...)
I disagree. Many people have gotten used to the idea of having multiple config files to choose from, thanks to MySQL. > Database benchmarks are things that many years of study have gone into - > this sort of homegrown effort is rather like a backyard attempt to > construct a Maserati. The lack of any testing of concurrency is very > telling. True, but in this case the lack of any kind of a reasonable config was a much bigger issue. Except for test 8, the numbers improved once he made a few config tweaks that I suggested (see the email thread I posted about a day or two ago for details). -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
