Rick Schumeyer wrote:
> 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