Re: Accounting for toast in query planner. (gin/gist indexes).

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Accounting for toast in query planner. (gin/gist indexes).
Дата
Msg-id 6406.1322803826@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Accounting for toast in query planner. (gin/gist indexes).  (jesper@krogh.cc)
Список pgsql-hackers
jesper@krogh.cc writes:
> Secondly I could bump the default cost of ts_match_vq/ts_match_qv a
> bit up, since the cost of doing that computation is probably not as
> cheap as a ordinary boolean function.

Actually, you could try bumping their costs up by more than "a bit".
It's a tad unfair to blame the toast access costs on the functions,
but it might get close enough to what you need.  If memory serves,
we don't charge those costs against index scans.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Inlining comparators as a performance optimisation
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Why so few built-in range types?