Gregory Stark <[EMAIL PROTECTED]> writes:
> I agree about the costs for evaluating the expressions. But a COLD update is
> certainly going to have to evaluate both expressions once. The only additional
> cost here is that HOT is going to have to evaluate the *old* expression as
> well. So it's at worst twice as expensive as a normal COLD update.
What's bothering me is the case where we evaluate the expression twice,
find it doesn't match, and fall through to the COLD update logic which
will do it a third time.
> I think I'm leaning towards doing a binary comparison of the
> parameters to the expressions.
Yeah, we could simply insist on no change to any column that's used by
any of the expressions. That would be cheap to test.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
