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 CFDB25282F for ; Tue, 19 Jul 2005 17:30: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 54368-09 for ; Tue, 19 Jul 2005 20:30:10 +0000 (GMT) Received: from tektite.k12usa.com (tektite.k12hq.com [12.160.186.24]) by svr1.postgresql.org (Postfix) with SMTP id BAB7852A90 for ; Tue, 19 Jul 2005 17:30:08 -0300 (ADT) Received: (qmail 66476 invoked by uid 1001); 19 Jul 2005 20:30:04 -0000 Date: Tue, 19 Jul 2005 16:30:04 -0400 From: Christopher Weimann To: Oliver Crosby Cc: Richard Huxton , pgsql-performance@postgresql.org Subject: Re: Looking for tips Message-ID: <20050719203004.GA4965@tektite.k12usa.internal> References: <1efd553a05071910427b290203@mail.gmail.com> <42DD420C.2010306@archonet.com> <1efd553a05071911413e50ea90@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1efd553a05071911413e50ea90@mail.gmail.com> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200507/325 X-Sequence-Number: 13566 On 07/19/2005-02:41PM, Oliver Crosby wrote: > > No queries in particular appear to be a problem. That could mean they are ALL a problem. Let see some EXPLAIN ANAYZE results just to rule it out. > At the moment it's just one user, With 1 user PostgreSQL will probobaly never beat MySQL but with hundreds it will.