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

Поиск
Список
Период
Сортировка
От Jason Long
Тема Is there any way to index or cache a view, or function results?
Дата
Msg-id 14038394.1151784545197.JavaMail.SYSTEM@server00-a4kpy5
обсуждение исходный текст
Список 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

http://www.supernovasoftware.com

HJBUG Founder and President

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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Postgresql does not start on reboot
Следующее
От: "Jason Long"
Дата:
Сообщение: Re: Is there any way to index or cache a view, or function results?