| 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 |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | a | 2006-07-01 20:32:59 | Re: db question - dynamic fields in db |
| Previous Message | Tom Lane | 2006-07-01 19:09:16 | Re: Postgresql does not start on reboot |