[ic] Performance of mysql versus postgressql

[Mike Clark]

Try starting postmaster like this instead of with standard defaults.

/usr/local/pgsql/bin/postmaster -B 1000 -o "-S 2000"

Bumping up shared buffer cache and sort blocks tends to help with Postgres
performance.

Also be aware that Postgres' strength lies in scalability as you load your
server. MySQL is quite likely to be faster under single-user or light loads.

Mike C.

----- Original Message -----
From: <c.willer@gmx.de>
To: <interchange-users@interchange.redhat.com>
Sent: Tuesday, December 11, 2001 10:12 AM
Subject: [ic] Performance of mysql versus postgressql


> Hello,
>
> Does anybody have experience with the perfomance of the postgressql
> database. Since Red hat sells his ecommerce solution package with
postgress I thought
> this must be quite fast and efficient. But when I installed postgressql on
> my system with 3700 product items I found that mysql is much faster in
> uploading a page. Mysql needs 1.7 sec and Postgressql needs 2.7 sec for
delivering
> the page. Did I set up the postgres databasesystem wrong?
>
> Can anybody share his knowledge about what king of computer hardware is
> neccessary to deliver the pages as a webserver. Is a Intel 866 Mhz Pentium
> processor with 255 MB RAM and an IDE harddrive enough to run a shop with
around
> 3700 product items. I would like to place my server (serverhoming)
dircetly at
> an company who has access to internet lines. Anbody has information about
the
> monthly fees in Germany for serverhosting.
>
> Thanks
>
> Christian Willer
>
>
> --
> GMX - Die Kommunikationsplattform im Internet.
> http://www.gmx.net
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users