Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 82D9E9FB3F0 for ; Mon, 26 Feb 2007 07:49:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 58202-04 for ; Mon, 26 Feb 2007 07:48:56 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.234]) by postgresql.org (Postfix) with ESMTP id B47629FB3F7 for ; Mon, 26 Feb 2007 07:49:06 -0400 (AST) Received: by wx-out-0506.google.com with SMTP id i28so1369361wxd for ; Mon, 26 Feb 2007 03:49:05 -0800 (PST) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=ugmUmE/1BnEB8z9Lp0RmyC4as4vidE/TN9XCajvAtk1pjmldLAA3s6aSIjg2gKjBG2DGMQJVYt84FLD12xBGavkTatHRbiC4S5IAmOjqRQpll6uW8C/oUnxMw1iXcJu4UnUKa8+RnVIodeJd3yZ0fpGLMKSgjAX6qAV6519oJSs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=JVtZ1yNQMeMfNgBqZFoXOlpPnxzktDKPADR2Y8tU2SVgg1PUo1LqvVNgyuhQy9UyOiywyDUk4Hs3RhwD1qly5o/AlmouIYc1EJ1HaD9Bs1RaIalpluitQnb7QfBZ6XHgSqUhLaUhb8G2namVfP7a6Hg1nKxLbFNFIIuxbF/pMV0= Received: by 10.90.98.10 with SMTP id v10mr4487426agb.1172490545682; Mon, 26 Feb 2007 03:49:05 -0800 (PST) Received: by 10.90.73.13 with HTTP; Mon, 26 Feb 2007 03:49:05 -0800 (PST) Message-ID: <7e4ba9550702260349r7c550aa2mb0b610874645b3c3@mail.gmail.com> Date: Mon, 26 Feb 2007 17:19:05 +0530 From: "Gauri Kanekar" To: pgsql-performance@postgresql.org Subject: Query Planner MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_57085_10844374.1172490545653" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/280 X-Sequence-Number: 23334 ------=_Part_57085_10844374.1172490545653 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi List, I have a Query. So when i do explain analyse on it , it shows me many Hash Joins. So is it possible to indicate the Query Planner not to consider Hash Join. -- Regards Gauri ------=_Part_57085_10844374.1172490545653 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Hi List,
 
I have a Query. So when i do explain analyse on it , it shows me many Hash Joins.
So is it possible to indicate the Query Planner not to consider Hash Join.

--
Regards
Gauri
------=_Part_57085_10844374.1172490545653--