Re: Wrong plan for simple join with index on FK

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas DCP SD
Тема Re: Wrong plan for simple join with index on FK
Дата
Msg-id E1539E0ED7043848906A8FF995BDA579010543B4@m0143.s-mxs.net
обсуждение исходный текст
Ответ на Wrong plan for simple join with index on FK  ("Pavel Stehule" <pavel.stehule@hotmail.com>)
Ответы Re: Wrong plan for simple join with index on FK
Список pgsql-hackers
> >These are all minor abberations though, on the whole the estimates
are
> >pretty good. Perhaps you need to tweak the values of random_page_cost
> >and similar variables.
>
> Thank You, It's general problem or only mine? I have "100%"
> standard current PC.

The default random_page_cost assumes some concurrent activity. If your
PC does nothing else concurrently, the performance of a seq scan will
be underestimated.

Try to do the statement with some concurrent disk load and you will most
likely
see that the 1. plan is faster. (assuming the tables are not fully
cached)

Andreas


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

Предыдущее
От: "Pavel Stehule"
Дата:
Сообщение: Re: Wrong plan for simple join with index on FK
Следующее
От: "Pavel Stehule"
Дата:
Сообщение: Re: Wrong plan for simple join with index on FK