Re: UPDATE and INDEX on expensive function with (IsCachable)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Albert REINER" <areiner(at)tph(dot)tuwien(dot)ac(dot)at>
Cc: PostgreSQL-Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: UPDATE and INDEX on expensive function with (IsCachable)
Date: 2001-05-04 16:41:32
Message-ID: 25682.988994492@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Albert REINER" <areiner(at)tph(dot)tuwien(dot)ac(dot)at> writes:
> Suppose some _cachable_ function f is expensive, but its results are
> often needed. So, to speed up queries, we have an index on
> f(table.field). I wonder what happens when we update a tuple of that
> table: will f be re-computed if table.field is not changed?

Yes.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Joel Burton 2001-05-04 20:15:21 Re: [PHP] psql with PHP question
Previous Message Joel Burton 2001-05-04 16:17:11 Re: Function Help