Re: Slow query in 8.2.0

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> 8.2 is a good bit more conservative than previous releases about
> optimizing views involving volatile functions, so I'm wondering whether
> that could have anything to do with it ...

Oh well, you are indeed right, I went through the whole view hierarchy
and replaced all volatile function calls (I used to use a trick
defining a function to avoid a join that used to perform better in
earlier versions) with explicit JOINs, also I relabeled some functions
that were indeed STABLE and now everything is working fine. I was
amazed that some of those views predates Postgres support of JOINs, I
guees we have been using Postgres for a very long time :-).

Just out of curiosity, why the change?

Regards,
Manuel.