Materialised view - refresh
Started by Krithika Venkateshover 8 years ago2 messagesgeneral
Hi
I have a materialised view which needs to refreshed every half an hour.
Is it possible to refresh the view without using triggers.
Do we have something similar to DBMS_SCHEDULER.CREATE_JOB in postgresql to
create a job that can be scheduled to refresh the views periodically.
Thanks in advance..
Import Notes
Reply to msg id not found: CAP7eca3TivFNr93hZsSiQni+Twd_qVpiM3KEf1zmrehxu0iRDQ@mail.gmail.comReference msg id not found: CAP7eca3m6tn4fove0U6ckScj0kUJJnNsfNKMzBK=E-TykhVQcA@mail.gmail.comReference msg id not found: CAP7eca334kNYX3nWzk_eVw+T-xskBMuGq=Cr9QT0==E5tT5F+g@mail.gmail.comReference msg id not found: CAP7eca3TivFNr93hZsSiQni+Twd_qVpiM3KEf1zmrehxu0iRDQ@mail.gmail.com
Re: Materialised view - refresh
You can use something like cron, windows task scheduler (if you're running
windows), pgagent (or jpgagent), pg_cron, or any of the others.
I personally use (and wrote) jpgagent, at the time pgagent was the only
alternative and it was very unstable for me. Here is the link if
interested: https://github.com/GoSimpleLLC/jpgAgent