Received: from localhost (pluto.hub.org [200.46.204.4]) by postgresql.org (Postfix) with ESMTP id 5ED669FA418 for ; Tue, 21 Nov 2006 10:45:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.4]) (amavisd-new, port 10024) with ESMTP id 41560-02 for ; Tue, 21 Nov 2006 10:44:47 -0400 (AST) X-Greylist: delayed 00:37:39.611602 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 5F3FD9FB1C4 for ; Tue, 21 Nov 2006 10:43:34 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from smtp-msa-out20.orange.fr (smtp20.orange.fr [193.252.22.29]) by svr4.postgresql.org (Postfix) with ESMTP id 2A1005AFAD4 for ; Tue, 21 Nov 2006 09:21:34 +0000 (GMT) Received: from [192.168.1.162] (LSt-Amand-152-32-6-178.w82-127.abo.wanadoo.fr [82.127.21.178]) by mwinf2016.orange.fr (SMTP Server) with ESMTP id 13E921C0009E; Tue, 21 Nov 2006 10:21:30 +0100 (CET) X-ME-UUID: 20061121092130816.13E921C0009E@mwinf2016.orange.fr Subject: BitMapScan performance degradation From: =?ISO-8859-1?Q?J=E9r=F4me?= BENOIS To: PostgreSQL Performance Cc: Xavier Milliard , Laurent BELMONTE Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-RogR3ev/6OcIbCUi7s5g" Date: Tue, 21 Nov 2006 10:21:29 +0100 Message-Id: <1164100889.5281.184.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.8.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50 X-Spam-Level: X-Archive-Number: 200611/171 X-Sequence-Number: 21941 --=-RogR3ev/6OcIbCUi7s5g Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi All, I have some problems with my sql query : select distinct INTEGER_VALUE,DATE_VALUE,EI_ID,VALUE_TYPE,FLOAT_VALUE,ID,TEXT_VALUE,CATEGOR= Y_ID,STRING_VALUE,CATEGORYATTR_ID,NAME from ((( select d_attribute as reqi= n2 where reqin2.CATEGORYATTR_ID =3D 1041947543 AND reqin2.TEXT_VALUE ilike = '%autrefois%' and ei_id in ( select distinct ei_id as EIID from MPNG2_ei_at= tribute as reqin3 where reqin3.NAME =3D 'CategoryID-1084520156' AND reqin3.= STRING_VALUE =3D '1084520156' ) ) ) ) ) as req0 join MPNG2_ei_attribute o= n req0.eiid =3D MPNG2_ei_attribute.ei_id order by ei_id asc; When enable_bitmapscan is enabled this query cost 51893.491 ms and when is disabled 117.709 ms. But i heard bitmapscan feature improved performance, can you help me ? You can read two results of EXPLAIN ANALYZE command here : http://sharengo.org/explain.txt Best Regards, J=C3=A9r=C3=B4me. --=20 J=C3=A9r=C3=B4me BENOIS Open-Source : http://www.sharengo.org Corporate : http://www.argia-engineering.fr JabberId : jerome.benois AT gmail.com --=-RogR3ev/6OcIbCUi7s5g Content-Type: application/pgp-signature; name=signature.asc Content-Description: Ceci est une partie de message =?ISO-8859-1?Q?num=E9riquement?= =?ISO-8859-1?Q?_sign=E9e?= -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (GNU/Linux) iD8DBQBFYsUZCDKlmlhpwnERArhlAJ9FdqTTTCCImBqudrNk9M9l6p//zgCfS9Jr aLUKQaY5191Zqj6Rl99Z0z0= =Njp9 -----END PGP SIGNATURE----- --=-RogR3ev/6OcIbCUi7s5g--