Super-smack?
От
Scott Sipe
Тема
Super-smack?
Дата
Msg-id
92F10BE1-B193-4EEA-877A-9260B55C2844@mindspring.com
Список
Дерево обсуждения
Super-smack? Scott Sipe <cscotts@mindspring.com>
Re: Super-smack? "Steinar H. Gunderson" <sgunderson@bigfoot.com>
Re: Super-smack? "Jim C. Nasby" <jnasby@pervasive.com>
Re: Super-smack? "Steve Woodcock" <steve.woodcock@gmail.com>
Re: Super-smack? Tom Lane <tgl@sss.pgh.pa.us>
Re: Super-smack? Tom Lane <tgl@sss.pgh.pa.us>
Re: Super-smack? Bruce Momjian <pgman@candle.pha.pa.us>
I've been attempting to tweak performance on a FreeBSD 6 server I'm running that has both Postgresql 8.1 and Mysql 4.1 running simultaneously. To attempt to gauge performance I was directed to the super-smack (http://vegan.net/tony/supersmack/) benchmark. Testing gave results that showed mysql far outperforming postgresql in select and update tests, in factors of roughly 6-7x in terms of queries per second (running stock configurations--I was able to improve mysql performance a good amount with playing with the config file settings, though I couldn't make any change in postgresql performance. I DID increase shmmin shmmax and semmap during the course of testing). So, my question is, before I do any further digging, is super-smack flawed? It's very possibile I'm doing something stupid with the execution of the benchmark too, but as I said, I just wanted to see if anyone else had used super-smack, or had comments? I'm glad to post system specs, configs, etc, if anyone is interested. Alternatively, would anyone recommend any other benchmarks to run? thanks much, Scott I also wanted to make clear I didn't want to turn this into a mysql vs postgresql discussion, as I much prefer postgresql.
В списке pgsql-performance по дате отправления