Tim Landscheidt <tim(at)tim-landscheidt(dot)de> writes:
> It seems that XMLPARSE() is called for every row without
> PostgreSQL realizing that it is IMMUTABLE.
Indeed, the system doesn't consider it immutable. None of the examples
you show would benefit if it did, though.
I believe there are GUC-parameter dependencies that prevent us from
treating it as truly immutable, but if you want to ignore that
consideration and force constant-folding anyway, you could wrap it
in a SQL function that's marked as IMMUTABLE.
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Krade||Date: 2009-07-20 20:48:54|
|Subject: Re: Full text search with ORDER BY performance issue|
|Previous:||From: Kenny Gorman||Date: 2009-07-20 19:21:02|
|Subject: Re: Used computers?|