From owner-freebsd-database Sat Nov 28 11:57:11 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id LAA08692 for freebsd-database-outgoing; Sat, 28 Nov 1998 11:57:11 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from thelab.hub.org (nat1001.mpoweredpc.net [142.177.191.239]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id LAA08687 for ; Sat, 28 Nov 1998 11:57:09 -0800 (PST) (envelope-from scrappy@hub.org) Received: from localhost (scrappy@localhost) by thelab.hub.org (8.9.1/8.9.1) with ESMTP id PAA04721; Sat, 28 Nov 1998 15:54:51 -0400 (AST) (envelope-from scrappy@hub.org) X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs Date: Sat, 28 Nov 1998 15:54:46 -0400 (AST) From: The Hermit Hacker To: John Fieber cc: Yani Brankov , andrew@squiz.co.nz, pgsql-hackers@postgresql.org, database@FreeBSD.ORG Subject: Re: Mysql 321 - Mysql 322 - msql In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Sat, 28 Nov 1998, John Fieber wrote: > In working with the two, I've also found a couple complicated > join queries where I just couldn't get the optimizer in > PostgreSQL (6.3.2 and 6.4) to do the right thing, resulting in > several minutes of processing per query, while mySQL did the same > query in the blink of an eye. You mention v6.4 above, so could you provide us with a way of "reproducing" the bug? Marc G. Fournier Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message