Re: BitMapScan performance degradation - Mailing list pgsql-performance

From db@zigo.dhs.org
Subject Re: BitMapScan performance degradation
Date
Msg-id 3389.192.121.104.120.1164121967.squirrel@zigo.dhs.org
Whole thread Raw
In response to BitMapScan performance degradation  (Jérôme BENOIS <benois@argia-engineering.fr>)
Responses Re: BitMapScan performance degradation
List pgsql-performance
> 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 ?

The standard question we always ask first is if you have run VACUUM
ANALYZE recently?

Are all the costs and estimated number of rows the same after you have run
VACUUM ANALYZE? If not you might want to show that new plan as well.

/Dennis

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: BitMapScan performance degradation
Next
From: Jérôme BENOIS
Date:
Subject: Re: BitMapScan performance degradation