Re: BitMapScan performance degradation

Поиск
Список
Период
Сортировка
От Jérôme BENOIS
Тема Re: BitMapScan performance degradation
Дата
Msg-id 1164123356.5281.256.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: BitMapScan performance degradation  (db@zigo.dhs.org)
Список pgsql-performance
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.

Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: db@zigo.dhs.org
Дата:
Сообщение: Re: BitMapScan performance degradation
Следующее
От: Joe Lester
Дата:
Сообщение: Slow Query