Re: Slow query: bitmap scan troubles

Поиск
Список
Период
Сортировка
От
Тема Re: Slow query: bitmap scan troubles
Дата
Msg-id 0b8b01cdd3b1$1a55b8b0$4f012a10$@foo.me.uk
обсуждение исходный текст
Ответ на Re: Slow query: bitmap scan troubles  (Sergey Konoplev <gray.ru@gmail.com>)
Список pgsql-performance
> I also wonder if increasing (say x10) of default_statistics_target or just
doing ALTER TABLE SET STATISTICS for particular tables will help.
> It will make planned to produce more precise estimations. Do not forget
ANALYZE afer changing it.

Thanks Sergey, I will try this too.

I think the bother here is that this statistics are pretty good (we do
analyse regularly and default_statistics_target is already 1000), but once I
start filtering the two tables the correlations alter quite a bit. I don't
think there is that much that can be done about that :)

- Phil




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

Предыдущее
От: Andrea Suisani
Дата:
Сообщение: Re: Re: xfs perform a lot better than ext4 [WAS: Re: Two identical systems, radically different performance]
Следующее
От:
Дата:
Сообщение: Re: Slow query: bitmap scan troubles