Thread: [GENERAL] Materialised view - refresh

[GENERAL] Materialised view - refresh

From

Krithika Venkatesh

Date:

11 July 2017, 09:28:55

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

Re: [GENERAL] Materialised view - refresh

From

Adam Brusselback

Date:

11 July 2017, 14:55:22

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