Re: Index Ignored Due To Use Of View

----- Original Message -----=20
  Sent: Wednesday, March 23, 2011 12:50 PM
  Subject: Index Ignored Due To Use Of View


  PostgreSQL 8.3.14
  OS: Linux Redhat 5.4

  Note: I have used the same subject for this email taken from an email: Po=
sted 2011-02-24 13:29:22-08 by "David Johnston", because this seems to be a=
 very similar observation.

  Bug/Problem Summary:
  We are using a simple query based on a simple view and the query optimize=
r is not choosing an index.=20
  The same query without the view is using an index.
  The same query on an almost identical view, but having either removed a s=
ingle column which was generated via a function call or replace the functio=
n call with equivalent SQL, then the query optimizer is choosing an index.

I found the solution to the problem and it would therefore appear as though=
 this is not a bug!
If I change the function definition to be "STABLE" instead of "VOLATILE", t=
hen the problem goes away.

Regards
Donald Fraser=