Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 9865C9FB3CF for ; Tue, 10 Jul 2007 11:47:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 15403-03 for ; Tue, 10 Jul 2007 11:47:12 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.176]) by postgresql.org (Postfix) with ESMTP id E0AE49FA35F for ; Tue, 10 Jul 2007 11:47:07 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id d32so3075553pye for ; Tue, 10 Jul 2007 07:47:06 -0700 (PDT) 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:content-transfer-encoding:content-disposition; b=HeNwd62jV4tHDFrHDuGI7iYjY2TnsufjWoetCHoF8zAS16IwdFF7e0jvVWF3wAT+hUDgBZeoWSh2bYuuspkGHI2DsxXZyXXb+wo3Ky+lqMvk4Fej9HBSg3mwaBRXHKoKLMP0fKT6GgQa2yittqQDX2Y2httNl5tsOpHmlxKbJCc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=qVCMOtIc5iUsejslVE5qlVrk34jG50mymHsocrHLI/PXTY/vFTTv5gNXRydtV8gzCBFM+O/N/4IyUd8nmyiQJOOcinP76t+tn9MN0KAtozkJPz5yUfnVgsJI5cgZvaWKcuZ9aG8HPWJpK/0imM+dJ0AnfYbuiSoJEJtzuXN7sQA= Received: by 10.115.109.1 with SMTP id l1mr4236817wam.1184078825540; Tue, 10 Jul 2007 07:47:05 -0700 (PDT) Received: by 10.115.60.3 with HTTP; Tue, 10 Jul 2007 07:47:05 -0700 (PDT) Message-ID: <7e4ba9550707100747r411cc2aex56f0c6d2fa273f73@mail.gmail.com> Date: Tue, 10 Jul 2007 20:17:05 +0530 From: "Gauri Kanekar" To: pgsql-performance@postgresql.org Subject: Query Analyser MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/74 X-Sequence-Number: 25758 Hi List, Is there anyway so as to indicate the Query Analyser not to use the plan which it is using regularly, and use a new plan ?