| From: | "David E(dot) Wheeler" <david(at)kineticode(dot)com> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Materialized views |
| Date: | 2011-11-09 00:15:29 |
| Message-ID: | B8C5EC11-D870-4493-9AC4-9AB0FD8C3FE7@kineticode.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Nov 8, 2011, at 3:25 PM, Josh Berkus wrote:
>> I'm about 99% sure the answer to that is 'yes'. Are you thinking of
>> having a background scheduler which handles the updating of
>> schedule-driven (instead of trigger-driven) MVs..? Not to try to
>> feature-creep this on you, but you might consider how a new backend
>> process which handles scheduled tasks could be generalized to go beyond
>> handling just MV updates.. :)
>
> No feature-creeping; the two features described will be hard enough.
> Besides, we have pg_agent for that.
Well, there has to be some way to refresh an MV at regular intervals, no?
Best,
David
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2011-11-09 00:19:00 | Re: Measuring relation free space |
| Previous Message | Tom Lane | 2011-11-08 23:39:19 | Re: lexemes in prefix search going through dictionary modifications |