Below are some PRELIMINARY results in comparing the performance of pgsql and mysql.
These results are for a single process populating a table with 934k rows,
and then performing some selects. I also compared the effect of creating indexes on some of the columns.
I have not yet done any testing of transactions, multiple concurrent processes, etc.
I did not make any changes to the default config settings. I can do so if someone has some suggestions.
My machine is a 3.0 GHz P4 with 1 GB ram, running FC 3.
Stop now. I've not looked at your test results, and frankly there is no point. As it ships, PG should run fine on a small corner of an old laptop. It will not perform well with any sort of serious workload on any sort of serious hardware. You're wasting your time if you want to get any sort of meaningful result.
Take 30 minutes to read through the article below. It covers the basics of how to manage your configuration settings.
http://www.powerpostgresql.com/PerfList
Oh - make sure you are accounting for caching effects as well. -- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
