| From: | Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: How to check if a materialised view is being updated? |
| Date: | 2021-01-19 11:24:39 |
| Message-ID: | 20210119122439.Horde.9d_ZmrfEXDiDXLMPmIUyXxM@webmail.gelassene-pferde.biz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> I’ve got a materialized view as a source for my ETL-process, and the
> materialized view takes several hours to refresh. During which it
> is locked for queries.
Would it be an option to split the process into a cascade of
materialized views to minimize the actual time of lock?
> So I’m looking for a way to identify if the refresh process is
> finished or if it’s still running - preferably without having to
> wait for timeout by querying a locked materialized view. But by
> e.g. using the system tables or otherwise.
I cannot answer this, however.
--
S/MIME Public Key: https://oc.gelassene-pferde.biz/index.php/s/eJuAUFONag6ofnH
Signal (Safer than WhatsApp): +49 1578 7723737
Threema (Safer than WhatsApp): A76MKH3J
Handys: +41 78 947 36 21 | +49 1578 772 37 37
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jayadevan M | 2021-01-19 11:33:33 | Re: How to check if a materialised view is being updated? |
| Previous Message | Myklebust | 2021-01-19 09:53:09 | How to check if a materialised view is being updated? |