X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 37955D1B43D for ; Fri, 2 Jan 2004 13: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 38807-05 for ; Fri, 2 Jan 2004 09:03:44 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 6D522D1B45C for ; Fri, 2 Jan 2004 09:03:41 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i02D3eU6031441 for ; Fri, 2 Jan 2004 13:03:40 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i02Cb1Mn006567 for pgsql-performance@postgresql.org; Fri, 2 Jan 2004 12:37:01 GMT From: Christopher Browne X-Newsgroups: comp.databases.postgresql.performance Subject: Tuning Techniques To Avoid? Date: Fri, 02 Jan 2004 07:33:46 -0500 Organization: cbbrowne Computing Inc Lines: 16 Message-ID: References: <200401021042.57714.herve@elma.fr> 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.1003 (Gnus v5.10.3) XEmacs/21.4 (Reasonable Discussion, linux) Cancel-Lock: sha1:DmG7XsX4zLYDs85FtnMSIc7wiaw= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/6 X-Sequence-Number: 5181 Here's a scheme for query optimization that probably needs to be avoided in that it would run afoul of a patent held by Oracle... It looks like what they have patented is pretty much a "greedy search" heuristic, starting by finding the table in a join that has the greatest selectivity (e.g. - where the number of entries selected is cut the most by the selection criteria), and then describes how to search for the "best" approach to joining in the other tables. -- output = reverse("gro.mca" "@" "enworbbc") http://www.ntlug.org/~cbbrowne/nonrdbms.html "If I could find a way to get [Saddam Hussein] out of there, even putting a contract out on him, if the CIA still did that sort of a thing, assuming it ever did, I would be for it." -- Richard M. Nixon