Request a Demo
Home   >   mailing lists

Re: BUG #7651: Superfluous calls to functions used for indexing - Mailing list pgsql-bugs

From Stuart Bishop
Subject Re: BUG #7651: Superfluous calls to functions used for indexing
Date
Msg-id CADmi=6MoMaiOP7zu0pWghAaNe4nONJwzGJUgnwXzeLdDru_43w@mail.gmail.com
Whole thread Raw
In response to BUG #7651: Superfluous calls to functions used for indexing  (m-pg@8d.no)
Responses Re: BUG #7651: Superfluous calls to functions used for indexing
List pgsql-bugs
Tree view 
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 by date:

Previous
From: chenhj@cn.fujitsu.com
Date:
Subject: BUG #7664: Program using libpq and ecpglib can not output native language
Next
From: ilfb@yahoo.com
Date:
Subject: BUG #7663: is not a bug but...