Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group