X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2F573D1B503 for ; Wed, 29 Oct 2003 20:04:31 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 87946-09 for ; Wed, 29 Oct 2003 16:04:00 -0400 (AST) Received: from perrin.nxad.com (internal.nxad.com [69.1.70.251]) by svr1.postgresql.org (Postfix) with ESMTP id 1CFAFD1B50D for ; Wed, 29 Oct 2003 16:03:59 -0400 (AST) Received: by perrin.nxad.com (Postfix, from userid 1001) id 7005721066; Wed, 29 Oct 2003 12:03:44 -0800 (PST) Date: Wed, 29 Oct 2003 12:03:44 -0800 From: Sean Chittenden To: mallah@trade-india.com Cc: pgsql-performance@postgresql.org, jesse@fsck.com Subject: Re: PostgreSQL 7.4beta5 vs MySQL 4.0.16 with RT(DBIx::SearchBuilder) Message-ID: <20031029200344.GA36028@perrin.nxad.com> References: <33280.203.145.130.142.1067455363.squirrel@mail.trade-india.com> <33288.203.145.130.142.1067456744.squirrel@mail.trade-india.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <33288.203.145.130.142.1067456744.squirrel@mail.trade-india.com> X-PGP-Key: finger seanc@FreeBSD.org X-PGP-Fingerprint: 3849 3760 1AFE 7B17 11A0 83A6 DD99 E31F BC84 B341 X-Web-Homepage: http://sean.chittenden.org/ User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/728 X-Sequence-Number: 4476 > So its not just PostgreSQL that is suffering from the bad SQL but > MySQL also. But the question is my does PostgreSQL suffer so badly > ?? I think not all developers write very nice SQLs. > > Its really sad to see that a fine peice of work (RT) is performing > sub-optimal becoz of malformed SQLs. [ specially on database of my > choice ;-) ] Post EXPLAIN ANALYZES of the queries you're running, then maybe you'll be able to get some useful help from this list. Until then, it's very hard to speculate as to why PostgreSQL is slower. -sc -- Sean Chittenden