Re: Gained %20 performance after disabling bitmapscan

Поиск
Список
Период
Сортировка
От Vladimir Ryabtsev
Тема Re: Gained %20 performance after disabling bitmapscan
Дата
Msg-id CAMqTPqm8ueo94ovPQuCeRkG5nK9mzLvnRgrQWBCrCVfcvuWbaQ@mail.gmail.com
обсуждение исходный текст
Ответ на Gained %20 performance after disabling bitmapscan  (Yavuz Selim Sertoglu <yavuzselim.sertoglu@medyasoft.com.tr>)
Ответы Ynt: Gained %20 performance after disabling bitmapscan
Список pgsql-performance
Yavuz, cannot add much to other points but as for index-only scan, an (auto)vacuum must be run in order to optimizer understand it can utilize index-only scan. Please check if autovacuum was run on the table after index creation and if no, run it manually.

Vlad

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Gained %20 performance after disabling bitmapscan
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Gained %20 performance after disabling bitmapscan