Is there any way to index or cache a view, or function results?

Lists: pgsql-general
From: "Jason Long" <jason(at)supernovasoftware(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Is there any way to index or cache a view, or function results?
Date: 2006-07-01 20:09:54
Message-ID: 14038394.1151784545197.JavaMail.SYSTEM@server00-a4kpy5
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Is it possible to define a function or view that performs fairly intensive
calculations and then index or cache these results?

The data I have will be accessed more than modified, but still will be
modified semi regularly.

Would someone please enlighten me on my options for improving performance is
this situation?

Thank you for your time,

Jason Long

CEO and Chief Software Engineer

BS Physics, MS Chemical Engineering

HYPERLINK "http://www.supernovasoftware.com"http://www.supernovasoftware.com

HJBUG Founder and President

HYPERLINK "http://www.hjbug.com"http://www.hjbug.com

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.9.8/380 - Release Date: 6/30/2006