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

UPDATE and INDEX on expensive function with (IsCachable)

From: "Albert REINER" <areiner(at)tph(dot)tuwien(dot)ac(dot)at>
To: PostgreSQL-Novice <pgsql-novice(at)postgreSQL(dot)org>
Subject: UPDATE and INDEX on expensive function with (IsCachable)
Date: 2001-05-04 09:59:13
Message-ID: 20010504115913.A557@frithjof (view raw or flat)
Thread:
Lists: pgsql-novice
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? What if
the update explicitly re-sets table.field to its old value?

Thanks in advance,

Albert.


Responses

pgsql-novice by date

Next:From: suhail sarwarDate: 2001-05-04 12:51:31
Subject: inserting multiple vales into multiple tables using 1 prepared statement
Previous:From: Andrew McMillanDate: 2001-05-04 08:07:44
Subject: Re: [NOVICE] Re: psql with PHP question

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