From: Jérôme BENOIS <benois@argia-engineering.fr>
To: PostgreSQL Performance <pgsql-performance@postgresql.org>
Cc: Xavier Milliard <milliard@argia.fr>
Cc: Laurent BELMONTE <belmonte@argia.fr>
Subject: BitMapScan performance degradation
Date: Tue, 21 Nov 2006 10:21:29 +0100
Message-ID: <1164100889.5281.184.camel@localhost.localdomain> (raw)
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,CATEGORY_ID,STRING_VALUE,CATEGORYATTR_ID,NAME from ((( select d_attribute as reqin2 where reqin2.CATEGORYATTR_ID = 1041947543 AND reqin2.TEXT_VALUE ilike '%autrefois%' and ei_id in ( select distinct ei_id as EIID from MPNG2_ei_attribute as reqin3 where reqin3.NAME = 'CategoryID-1084520156' AND reqin3.STRING_VALUE = '1084520156' ) ) ) ) ) as req0 join MPNG2_ei_attribute on req0.eiid = 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érôme.
--
Jérôme BENOIS
Open-Source : http://www.sharengo.org
Corporate : http://www.argia-engineering.fr
JabberId : jerome.benois AT gmail.com
Attachments:
signature.asc (application/pgp-signature, 188B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: benois@argia-engineering.fr, milliard@argia.fr, belmonte@argia.fr
Subject: Re: BitMapScan performance degradation
In-Reply-To: <1164100889.5281.184.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox