> You could check for volatile functions. I think this could be done safely.
I don't think that's enough. A UDA like last() could have an immutable
sfunc, but still be sensitive to the sort order. I think you'd need
something like a special order-sensitive aggregate definition flag.
Maciek Sakrejda | System Architect | Truviso
1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
(650) 242-3500 Main
In response to
pgsql-performance by date
|Next:||From: mark||Date: 2010-09-14 16:10:33|
|Subject: Held idle connections vs use of a Pooler|
|Previous:||From: Merlin Moncure||Date: 2010-09-14 12:01:05|
|Subject: Re: Major performance problem after upgrade from 8.3 to 8.4|