Re: Materialised view - refresh

From: Adam Brusselback <adambrusselback(at)gmail(dot)com>
To: Krithika Venkatesh <krithikavenkatesh31(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Materialised view - refresh
Date: 2017-07-11 11:55:22
Message-ID: CAMjNa7c2q7xsJZZ7bJCXEZ2Mx=RbbnEodahmB2dyyDLnsvUz0g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2017-07-11 12:36:33 Re: Imperative Query Languages
Previous Message Albe Laurenz 2017-07-11 07:28:52 Re: tsquery error