Re: Premature view materialization in 8.2? - Mailing list pgsql-performance

From Jonathan Ellis
Subject Re: Premature view materialization in 8.2?
Date
Msg-id e06563880704061326q7872d8a8q3ab44e6971f80746@mail.gmail.com
Whole thread Raw
In response to Re: Premature view materialization in 8.2?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On 4/6/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > The problem seems to be that clan_members_v contains a call to an
> > expensive function:
>
> I'll bet that the function is marked VOLATILE.  8.2 is more conservative
> about optimizing away volatile functions than previous releases.  If
> it has no side effects, mark it STABLE (or can it even be IMMUTABLE?).

That's exactly right, it should have been STABLE.

Thanks a lot for figuring that out for me!

pgsql-performance by date:

Previous
From: Ron
Date:
Subject: Re: SCSI vs SATA
Next
From: "Alex Deucher"
Date:
Subject: postgres 8.2 seems to prefer Seq Scan