On Mon, 2005-03-07 at 12:00, Rick Schumeyer wrote: > Iâm interested in comparing the performance of postgresql and mysql > > on various combinations of user loads and database sizes. I have seen > > a few statements to the effect of âmysql is faster for small, low use > > applications, but postgresql is better for bigger stuffâ. I would > like > > to run some independent tests to see if this is true. > > > > Before I do this, has anyone done this already, with the latest > > versions of both? I think Iâve seen some comparisons that are > > somewhat dated. > > > > Does anyone have any pointers on what to do or not do? Or > > would anyone be willing to comment on an experiment plan > > and suggest improvements? Any help or references are appreciated.
Look at the OSDL test suite, and run as much (or as little) of it as you can against both databases. it's a rather large and complex couple of suites. Test under heavy parallel use. Test returning large data sets from complex queries, esp OLAP type queries that do a lot of work in one query to mine data in certain ways. Tune both reasonably according the the best practices for each database. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
