Re: Gained %20 performance after disabling bitmapscan

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Gained %20 performance after disabling bitmapscan
Дата
Msg-id CAMkU=1wyTzvG7smk=xK7mnrZf4-WBakPoBNny1X4oceXUq1c1w@mail.gmail.com
обсуждение исходный текст
Ответ на Ynt: Gained %20 performance after disabling bitmapscan  (Yavuz Selim Sertoglu <yavuzselim.sertoglu@medyasoft.com.tr>)
Список pgsql-performance
Дерево обсуждения
On Mon, Oct 22, 2018 at 3:20 AM Yavuz Selim Sertoglu <yavuzselim.sertoglu@medyasoft.com.tr> wrote:

Thanks for the reply Jeff,

I know 20ms is nothing but it shows me that there is a problem with my configuration. I want to find it.


This is a dangerous assumption.  This is no configuration you can come up with which will cause the planner to be within 20% of perfection in all cases.  Given the other plans you've shown and discussed, I think this is just chasing our own tail.

Cheers,

Jeff

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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: DELETE / UPDATE from partition not optimized (11.0)
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: DELETE / UPDATE from partition not optimized (11.0)