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 1F8335292F for ; Mon, 6 Jun 2005 14:50:18 -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 57921-05 for ; Mon, 6 Jun 2005 17:50:06 +0000 (GMT) Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7631D52805 for ; Mon, 6 Jun 2005 14:50:04 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 2FD9130952; Mon, 6 Jun 2005 19:46:21 +0200 (MET DST) From: Christopher Browne X-Newsgroups: pgsql.performance Subject: Re: Need help to decide Mysql vs Postgres Date: Mon, 06 Jun 2005 13:01:23 -0400 Organization: cbbrowne Computing Inc Lines: 24 Message-ID: References: <0C072E7CC947D511AC9600A0CC7341200256CF37@xeon400.tagaudit.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4 (Jumbo Shrimp, linux) Cancel-Lock: sha1:0VG4wbdDXjrRhR7Dn5mLh9oZdik= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.386 tagged_above=0 required=5 tests=AWL, INFO_TLD X-Spam-Level: X-Archive-Number: 200506/127 X-Sequence-Number: 12764 In the last exciting episode, ashah@tagaudit.com (Amit V Shah) wrote: >> I am all for postgres at this point, however just want to know why I am >> getting opposite results !!! Both DBs are on the same machine > >> Why do you say "opposite results" ? > > Please pardon my ignorance, but from whatever I had heard, mysql was > supposedly always faster than postgres !!!! Thats why I was so > surprised !! I will definately post the "analyze query" thing by > end of today ... There is a common "use case" where MySQL(tm) using the "MyISAM" storage manager tends to be quicker than PostgreSQL, namely where you are submitting a lot of more-or-less serial requests of the form: select * from some_table where id='some primary key value'; If your usage patterns differ from that, then "what you heard" won't necessarily apply to your usage. -- output = ("cbbrowne" "@" "acm.org") http://linuxdatabases.info/info/rdbms.html The difference between a child and a hacker is the amount he flames about his toys. -- Ed Schwalenberg