Home > mailing lists

Is there any way to index or cache a view, or function results? - Mailing list pgsql-general

From	Jason Long
Subject	Is there any way to index or cache a view, or function results?
Date	July 1, 2006 20:42:58
Msg-id	14038394.1151784545197.JavaMail.SYSTEM@server00-a4kpy5 Whole thread Raw
List	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

HJBUG Founder and President

--
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

From: Tom Lane
Date: 01 July 2006, 19:09:31
Subject: Re: Postgresql does not start on reboot

From: "Jason Long"
Date: 01 July 2006, 21:36:54
Subject: Re: Is there any way to index or cache a view, or function results?