Hi Dennis,
Le mardi 21 novembre 2006 à 16:12 +0100, db@zigo.dhs.org a écrit :
> > 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?
Yes i ran VACCUUM ANALYZE just before my EXPLAIN.
> 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
Jérôme.
