Re: BUG #7651: Superfluous calls to functions used for indexing

Поиск
Список
Период
Сортировка
От Stuart Bishop
Тема Re: BUG #7651: Superfluous calls to functions used for indexing
Дата
Msg-id CADmi=6MoMaiOP7zu0pWghAaNe4nONJwzGJUgnwXzeLdDru_43w@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #7651: Superfluous calls to functions used for indexing  (m-pg@8d.no)
Ответы Re: BUG #7651: Superfluous calls to functions used for indexing  (Morten Minde Neergaard <m@8d.no>)
Список pgsql-bugs
On Sun, Nov 11, 2012 at 10:45 PM,  <m-pg@8d.no> wrote:

> Bug: When making an index over a function, then selecting a result that does
> not contain the function call (but orders on it), Superfluous function calls
> are made. This possibly because the plan creates a projection containing the
> function value.

I think this is the same issue as was discussed here, dating from
PostgreSQL 8.1:

http://postgresql.1045698.n5.nabble.com/Slow-functional-indexes-td2059587.html


--
Stuart Bishop <stuart@stuartbishop.net>
http://www.stuartbishop.net/

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

Предыдущее
От: chenhj@cn.fujitsu.com
Дата:
Сообщение: BUG #7664: Program using libpq and ecpglib can not output native language
Следующее
От: ilfb@yahoo.com
Дата:
Сообщение: BUG #7663: is not a bug but...