I've worked with both extensively. My personal preference is PG. However, here are my findings over the years.
The biggest factor in performance is the size of the database, more than anything else. If you have a small and relatively simple RDB structure, MySQL is significantly faster. (this is changing however. PG has made some significant improvements in speed this last year, but MySQL is improving performance considerably with larger and more complex RDBs.) PG has a much flatter performance line regardless of db size, whereas MySQL just gets much slower and slower as the db MB increases. -D AdPak Communications, Inc. Network Security Products, Sales & Support (623) 936-4800 * Toll Free 1-888-600-7066 * Fax: (623) 936-4111 Who Is Watching Your Network? Corporate/Sales/Service: www.adpak.com -----Original Message----- From: Ryan Jameson (USA) [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 1:18 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] postgresql vs mysql There's a substantiated rumor that says postgres is faster for complex queries. <>< Ryan -----Original Message----- From: Ellen Solomon [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 12:58 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] postgresql vs mysql I'm starting a project for which the lead programmer wants to use postgresql. I'll be working in php. Any major disadvantages to postgresql over mysql, other than mysql seems to be more widespread? TIA Ellen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php