Re: Slow query in 8.2.0

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>
Cc: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Slow query in 8.2.0
Date: 2006-12-14 00:47:29
Message-ID: 13715.1166057249@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx> writes:
> 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 ...

> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2006-12-14 02:04:10 Re: forcing compression of text field
Previous Message Manuel Sugawara 2006-12-14 00:32:03 Re: Slow query in 8.2.0