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 jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461