Re: pg_trgm indexes giving bad estimations?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_trgm indexes giving bad estimations?
Дата
Msg-id 5872.1160013267@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_trgm indexes giving bad estimations?  (Ben <bench@silentmedia.com>)
Ответы Re: pg_trgm indexes giving bad estimations?  (Ben <bench@silentmedia.com>)
Список pgsql-performance
Ben <bench@silentmedia.com> writes:
> How can I get the planner to not expect so many rows to be returned?

Write an estimation function for the pg_trgm operator(s).  (Send in a
patch if you do!)  I see that % is using "contsel" which is only a stub,
and would likely be wrong for % even if it weren't.

> A possibly related question is: because pg_tgrm lets me set the
> matching threshold of the % operator, how does that affect the planner?

It hasn't a clue about that.

            regards, tom lane

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

Предыдущее
От: Ben
Дата:
Сообщение: pg_trgm indexes giving bad estimations?
Следующее
От: Steve Peterson
Дата:
Сообщение: Re: UPDATE becomes mired / win32