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

2012-11-16 Thread Morten Minde Neergaard
At 14:44, Thu 2012-11-15, Jeff Davis wrote: […] > It's possible that the function call may be unnecessary, but that is > more of a performance enhancement, not a bug. For me it's a matter of orders of size of performance, so it feels like a bug ;p > Also, the example function has side effects. If

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

2012-11-15 Thread Stuart Bishop
On Sun, Nov 11, 2012 at 10:45 PM, 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.

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

2012-11-15 Thread Jeff Davis
On Sun, 2012-11-11 at 15:45 +, m...@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 > functio

[BUGS] BUG #7651: Superfluous calls to functions used for indexing

2012-11-11 Thread m-pg
The following bug has been logged on the website: Bug reference: 7651 Logged by: Morten Minde Neergaard Email address: m...@8d.no PostgreSQL version: 9.1.6 Operating system: Debian Wheezy Description: Bug: When making an index over a function, then selecting a result