Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 15CB92E003C for ; Mon, 24 Mar 2008 23:16:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 51886-01 for ; Mon, 24 Mar 2008 23:16:38 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.180]) by postgresql.org (Postfix) with ESMTP id 8FF762E002D for ; Mon, 24 Mar 2008 23:16:38 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id m38so3777489waf.5 for ; Mon, 24 Mar 2008 19:16:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=0//NUOLda+VFSDU/fVpGD8wAJUDGb6rXRHX8KigOkmE=; b=L+qutUOvWLXmFiCS2D0gkzp+5yuMZAMtkQU+J9h+wVsCwY0MFuliZOdANr9xgD8B//TbvZ2G1k/stEMPGtuBy1/OYokNmSAo6SkmXxK34Vv7ga76Ceu7TkgkGhdwmBbMSdZWM8QTmYXFKtnCLOTpwAkf+fD9CrhHZn679Kzpd28= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=tdfaauvlbszei4mZ4dnaG7GOfuF1A/xU1UGdT/4RTZTNcVHBX0XcV16kOziEmYPk6NntiCGhikO0LvmUTQxCrRwe2Mnp1dY7ALXO2dnCrPTWaU1av9TtuSJGqBHmtgrSaZLa/V05Ih41wKg1ORio+iBa87485ZRoG7NKOOic8dE= Received: by 10.114.157.1 with SMTP id f1mr13198915wae.10.1206411397273; Mon, 24 Mar 2008 19:16:37 -0700 (PDT) Received: by 10.114.137.7 with HTTP; Mon, 24 Mar 2008 19:16:37 -0700 (PDT) Message-ID: Date: Mon, 24 Mar 2008 20:16:37 -0600 From: "Scott Marlowe" To: "petchimuthu lingam" Subject: Re: bitmap heap scanning Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/200 X-Sequence-Number: 28683 On Mon, Mar 24, 2008 at 4:13 AM, petchimuthu lingam wrote: > How to enable bitmap heap scanning, my query is not using the scanning, i am > using postgresql 8.1 version. > i have enabled the option in the postgresql.conf, but still it is not using. It's likely enabled, but the query planner thinks that another method of doing things. What does explain analyze select ... say about your query plan?