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 D24CA52803 for ; Wed, 25 May 2005 12:52:37 -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 28450-08 for ; Wed, 25 May 2005 15:52:31 +0000 (GMT) Received: from zhonka1.zhonka.net (zhonka1.zhonka.net [66.228.195.5]) by svr1.postgresql.org (Postfix) with ESMTP id 6980152888 for ; Wed, 25 May 2005 12:52:30 -0300 (ADT) Received: from wolf.pjkh.com ([66.228.196.74]) by zhonka1.zhonka.net (Post.Office MTA v3.5.3 release 223 ID# 0-58414U4500L450S0V35) with ESMTP id net; Wed, 25 May 2005 08:52:29 -0700 Received: from localhost (localhost [127.0.0.1]) by wolf.pjkh.com (Postfix) with ESMTP id 2665458C9; Wed, 25 May 2005 08:52:25 -0700 (PDT) Received: from wolf.pjkh.com ([127.0.0.1]) by localhost (wolf.pjkh.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 65145-08; Wed, 25 May 2005 08:52:25 -0700 (PDT) Received: by wolf.pjkh.com (Postfix, from userid 1000) id E86E958C8; Wed, 25 May 2005 08:52:24 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by wolf.pjkh.com (Postfix) with ESMTP id E2A3458C7; Wed, 25 May 2005 08:52:24 -0700 (PDT) Date: Wed, 25 May 2005 08:52:24 -0700 (PDT) From: Philip Hallstrom To: Amit V Shah Cc: "'pgsql-performance@postgresql.org'" Subject: Re: Need help to decide Mysql vs Postgres In-Reply-To: <42939E47.8030201@commandprompt.com> Message-ID: <20050525085111.G65597@wolf.pjkh.com> References: <0C072E7CC947D511AC9600A0CC7341200256CF04@xeon400.tagaudit.com> <42939E47.8030201@commandprompt.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at pjkh.com X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200505/387 X-Sequence-Number: 12551 >> Thanks for the prompt reply !! Actually migration is inevitable. We have a >> totally messed up schema, not normalized and stuff like that. So the goal >> of >> the migration is to get a new and better normalized schema. That part is >> done already. Now the decision point is, should we go with postgres or >> mysql. Coming in a little late, but you might find these links interesting... not sure how up to date and/or accurate they are, but might give you some things to look into. http://sql-info.de/mysql/gotchas.html http://sql-info.de/postgresql/postgres-gotchas.html