Search Postgresql Archives

Materialised view - refresh

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Materialised view - refresh
From: Krithika Venkatesh <krithikavenkatesh31@xxxxxxxxx>
Date: Tue, 11 Jul 2017 11:58:55 +0530
In-reply-to: <CAP7eca3TivFNr93hZsSiQni+Twd_qVpiM3KEf1zmrehxu0iRDQ@mail.gmail.com>
References: <CAP7eca3m6tn4fove0U6ckScj0kUJJnNsfNKMzBK=E-TykhVQcA@mail.gmail.com> <CAP7eca334kNYX3nWzk_eVw+T-xskBMuGq=Cr9QT0==E5tT5F+g@mail.gmail.com> <CAP7eca3TivFNr93hZsSiQni+Twd_qVpiM3KEf1zmrehxu0iRDQ@mail.gmail.com>

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Materialised view - refresh
  - From: Adam Brusselback

Prev by Date: tsquery error
Next by Date: Re: tsquery error
Previous by thread: tsquery error
Next by thread: Re: Materialised view - refresh
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux