From: | Sam Mason <sam(at)samason(dot)me(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Division by zero |
Date: | 2009-06-04 15:59:44 |
Message-ID: | 20090604155944.GU5407@samason.me.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Jun 04, 2009 at 11:17:39AM -0400, Tom Lane wrote:
> Sam Mason <sam(at)samason(dot)me(dot)uk> writes:
> > I think that with 8.3 at least I'm going to carry on putting
> > IMMUTABLE on where I think it should be. Consider:
>
> there are corner cases where it's useful to have the function
> marked correctly rather than sloppily.
I think I originally noticed it when I'd written an "implies" operator
(i.e. (NOT $1) OR $2, as I don't trust myself to remember the logic)
and queries were running slowly until I noticed that a view was using
it deep inside itself somewhere. Seems like views would trigger this
behavior pretty reliably.
Doesn't seem like it needs fixing too urgently though.
--
Sam http://samason.me.uk/
From | Date | Subject | |
---|---|---|---|
Next Message | Jennifer Trey | 2009-06-04 16:01:33 | Re: Re: High I/O writes activity on disks causing images on browser to lag and not load |
Previous Message | Jennifer Trey | 2009-06-04 15:54:26 | Re: Re: High I/O writes activity on disks causing images on browser to lag and not load |