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

From: Stuart Bishop <stuart(at)stuartbishop(dot)net>
To: m-pg(at)8d(dot)no
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7651: Superfluous calls to functions used for indexing
Date: 2012-11-16 04:40:38
Message-ID: CADmi=6MoMaiOP7zu0pWghAaNe4nONJwzGJUgnwXzeLdDru_43w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sun, Nov 11, 2012 at 10:45 PM, <m-pg(at)8d(dot)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(at)stuartbishop(dot)net>
http://www.stuartbishop.net/

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2012-11-16 05:22:16 Re: BUG #7664: Program using libpq and ecpglib can not output native language
Previous Message chenhj 2012-11-16 03:48:42 BUG #7664: Program using libpq and ecpglib can not output native language