RE: Performance Spamassin PostgreSQL vs MySQL
We had an awkward setup, which forced us to use PGSQL for SpamAssassin. Unfortunately the SA queries are not processed well by PGSQL. Back in January we switched SA processing to MySQL. Bingo! Instant improvement in overall performance, and no PGSQL maintenance required. This is not sophisticated box - about 3 yr old, 2Mbytes RAM. - Miles Date: Wed, 18 Mar 2009 12:53:45 -0700 Subject: Performance Spamassin PostgreSQL vs MySQL From: mussa...@csz.com To: mysql@lists.mysql.com We are using the PostgreSQL currently to store the Bayes information. It seems to periodically spend a lot of time 'vacumming' which of course drives up disk load. The system admin has adjusted it so it only does this at low load. I'm curious if anyone has actually tested the PostgreSQL vs MySQL versions. We are currently running a uniprocessor system (Linux version 2.6.18-6-vserver-amd64 (Debian 2.6.18.dfsg.1-24). System appears disk limited, we have the files on hardware raid 0 and have moved nearly everything else off that set (they are the fastest drives). Just curious. Thanks. Bill Mussatto CyberStrategies, Inc. www.csz.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=one.point@hotmail.com _ Share photos with friends on Windows Live Messenger http://go.microsoft.com/?linkid=9650734
Re: Performance Spamassin PostgreSQL vs MySQL
At 02:53 PM 3/18/2009, you wrote: We are using the PostgreSQL currently to store the Bayes information. It seems to periodically spend a lot of time 'vacumming' which of course drives up disk load. The system admin has adjusted it so it only does this at low load. I'm curious if anyone has actually tested the PostgreSQL vs MySQL versions. We are currently running a uniprocessor system (Linux version 2.6.18-6-vserver-amd64 (Debian 2.6.18.dfsg.1-24). System appears disk limited, we have the files on hardware raid 0 and have moved nearly everything else off that set (they are the fastest drives). Just curious. Thanks. Bill Mussatto CyberStrategies, Inc. www.csz.com When the db is not vacuuming, how is the speed? PostgreSQL is far superior to MySQL for multi-processor CPU's. But if you are sure the CPU level is low, then adding more CPU's is not going to help. When you say you are storing Bayes information, are you referring to Bayes' theorem so you are storing mostly numbers (Doubles?)? How large are your tables (# of rows, row length disk space?) Are the rows being deleted or updated repeatedly? If not, then why do you need vacuuming? Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Performance Spamassin PostgreSQL vs MySQL
We are using the PostgreSQL currently to store the Bayes information. It seems to periodically spend a lot of time 'vacumming' which of course drives up disk load. The system admin has adjusted it so it only does this at low load. I'm curious if anyone has actually tested the PostgreSQL vs MySQL versions. We are currently running a uniprocessor system (Linux version 2.6.18-6-vserver-amd64 (Debian 2.6.18.dfsg.1-24). System appears disk limited, we have the files on hardware raid 0 and have moved nearly everything else off that set (they are the fastest drives). Just curious. Thanks. Bill Mussatto CyberStrategies, Inc. www.csz.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
POSTGRESQL VS MYSQL
Hello, I was wondering if anybody new of any articles out there that benchmarked mysql and postgresql recently.I have a few that have favored and have not seen any other ones that favor mysql accept for the benchmarks on the mysql website Thanks Randy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php