Re: function(contants) evaluated for every row - Mailing list pgsql-hackers

From Tom Lane
Subject Re: function(contants) evaluated for every row
Date
Msg-id 18279.1290629954@sss.pgh.pa.us
Whole thread Raw
In response to Re: function(contants) evaluated for every row  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> I realize they can't be converted to constants before the query starts
> but is there a reason we can't convert those functions to constants in
> the executor before a table scan?

Other than the significant number of cycles that would be wasted (in
most cases) checking for the possibility, probably not.  I'm dubious
that it would average out to a win though.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: profiling connection overhead
Next
From: Peter Eisentraut
Date:
Subject: Re: Per-column collation