X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E4EC552872 for ; Mon, 6 Jun 2005 15:55:22 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 72369-05 for ; Mon, 6 Jun 2005 18:55:13 +0000 (GMT) Received: from smtp102.mail.sc5.yahoo.com (smtp102.mail.sc5.yahoo.com [216.136.174.140]) by svr1.postgresql.org (Postfix) with SMTP id 75F38528A7 for ; Mon, 6 Jun 2005 15:55:12 -0300 (ADT) Received: (qmail 22011 invoked from network); 6 Jun 2005 18:55:12 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=Yahoo.com; h=Received:Message-ID:Date:From:User-Agent:X-Accept-Language:MIME-Version:To:CC:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding; b=Kex2C0+6Bq/3FerOhWn9DT2DqXWum9ZgTSA5qu0YqG6VcTj9hkIqfplwdZn6P1fmFntJqojtg3n+1xdU/3CcGv6Gs9263OAwsWClPrbrHVNhCQ1WwpJPYKdAX1LdiRGf2ZW6uCpupfL8ZjaCseSZ9aMg2r5Aj+vHziRKwlYLZGw= ; Received: from unknown (HELO jupiter.black-lion.info) (janwieck@68.80.245.191 with login) by smtp102.mail.sc5.yahoo.com with SMTP; 6 Jun 2005 18:55:12 -0000 Received: from [172.21.8.23] (ismtp.afilias.com [216.217.55.254]) (authenticated bits=0) by jupiter.black-lion.info (8.12.10/8.12.9) with ESMTP id j56ItAwC014456; Mon, 6 Jun 2005 14:55:10 -0400 (EDT) (envelope-from JanWieck@Yahoo.com) Message-ID: <42A49C1B.4010701@Yahoo.com> Date: Mon, 06 Jun 2005 14:55:23 -0400 From: Jan Wieck User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.1) Gecko/20040707 X-Accept-Language: en-us, en MIME-Version: 1.0 To: PFC Cc: Amit V Shah , pgsql-performance@postgresql.org Subject: Re: Need help to decide Mysql vs Postgres References: <0C072E7CC947D511AC9600A0CC7341200256CF37@xeon400.tagaudit.com> In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.838 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, FORGED_RCVD_HELO, RCVD_IN_NJABL_DUL, RCVD_IN_SORBS_DUL X-Spam-Level: ** X-Archive-Number: 200506/132 X-Sequence-Number: 12769 On 6/6/2005 2:12 PM, PFC wrote: > >> Please pardon my ignorance, but from whatever I had heard, mysql was >> supposedly always faster than postgres !!!! Thats why I was so surprised >> !! > > I heard a lot of this too, so much it seems common wisdom that postgres > is slow... well maybe some old version was, but it's getting better at > every release, and the 8.0 really delivers... The harder it is to evaluate software, the less often people reevaluate it and the more often people just "copy" opinions instead of doing an evaluation at all. Today there are a gazillion people out there who "know" that MySQL is faster than PostgreSQL. They don't know under what circumstances it is, or what the word "circumstances" means in this context anyway. When you ask them when was the last time they actually tested this you get in about 99% of the cases an answer anywhere between 3 years and infinity (for all those who never did). The remaining 1% can then be reduced to an insignificant minority by asking how many concurrent users their test simulated. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #