Re: Slow query in 8.2.0 - Mailing list pgsql-general

From Tom Lane
Subject Re: Slow query in 8.2.0
Date
Msg-id 13715.1166057249@sss.pgh.pa.us
Whole thread Raw
In response to Re: Slow query in 8.2.0  (Manuel Sugawara <masm@fciencias.unam.mx>)
List pgsql-general
Manuel Sugawara <masm@fciencias.unam.mx> writes:
> Tom Lane <tgl@sss.pgh.pa.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 ...

> Just out of curiosity, why the change?

People complained about getting wrong/surprising answers due to
unexpected multiple evaluations of volatile functions.

            regards, tom lane

pgsql-general by date:

Previous
From: Manuel Sugawara
Date:
Subject: Re: Slow query in 8.2.0
Next
From: Bruce Momjian
Date:
Subject: Re: forcing compression of text field