Recommendations for Bugzilla hardware
bbaetz at acm.org
Thu Oct 20 08:12:07 UTC 2005
On Wed, Oct 19, 2005 at 12:51:54PM -0700, Max Kanat-Alexander wrote:
> On Wed, 2005-10-19 at 09:59 +0800, byron wrote:
> > has anyone benchmarked mysql vs postgresql?
> I did some very brief, somewhat crude testing just now on landfill.
> Basically, I just ran a simple query over and over:
> time ./buglist.cgi "resolution=---&order=bugs.bug_id" > /dev/null
Most of the time is going to be in the perl in that case. my testing (a
couple of years ago) was that mysql was faster for simple queries, but
anything involving joins (eg searched on longdesc) were a lot faster in
postgres due to its query planner. 1750 bugs will all be in RAM, though,
so the difference should be almost nothing
More information about the developers