[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Refresh materialized view only when it's necessary
From: Guillaume ARNAUD <guillaume.arnaud () ledepartement82 ! fr>
Date: 2020-04-02 13:19:12
Message-ID: c3cd9728-65ef-5d8b-fad8-a60560427032 () ledepartement82 ! fr
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Hi again,
i see
(https://stackoverflow.com/questions/29437650/how-can-i-ensure-that-a-materialized-view-is-always-up-to-date) \
i can do it with an external program pgsidekick which catch notify :
https://github.com/wttw/pgsidekick .
It's the first time i try to install a program and when i wrote make ,
the program don't find pg_config and libpq-fe.h :
I try with no attributes, with -I /usr/pgsql-9.5/include/ and with -I
/usr/pgsql-9.5/ . none of them works.
pg_config is in /usr/pgsql-9.5/bin
libpq-fe.h is in /usr/pgsql-9.5/include
Thanks for your help
------------------------------------------------------------------------
Logo CD82 <http://www.ledepartement.fr> Guillaume ARNAUD
Technicien SIG
Cellule SIGD
Direction des systèmes informatiques et de télécommunication
Pôle coordination et ressources
Tél : 05 63 91 82 37
guillaume.arnaud@ledepartement82.fr
------------------------------------------------------------------------
Le 01/04/2020 à 18:12, J.J. Green a écrit :
> Hi Guillaume
>
> > Hello, I need to refresh a materialized view in my database,
>
> I've faced similar problems with complex derived data being too
> much for a view and finding the lack of incremental update on
> the standard PG materialised views means I could only update very
> occasionally.
>
> In the end, I managed to get a working solution with a "manually
> materialised view", so this is just a regular table, and I have
> triggers which wait for new data, and when they run they insert
> the new suitably modified rows into that table.
>
> This is _not easy_, there are lots of gotchas and edge-cases,
> for my case the underlying problem was not too hard, it was just
> that underlying data was too damn big.
>
> The code was commercial, so I'm afraid I can't post it.
>
> Bon chance !
>
> Jim
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
[Attachment #5 (multipart/related)]
[Attachment #7 (text/html)]
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi again,</p>
<p>i see
(<a class="moz-txt-link-freetext" \
href="https://stackoverflow.com/questions/29437650/how-can-i-ensure-that-a-materialize \
d-view-is-always-up-to-date">https://stackoverflow.com/questions/29437650/how-can-i-ensure-that-a-materialized-view-is-always-up-to-date</a>)
i can do it with an external program pgsidekick which catch notify
: <a class="moz-txt-link-freetext" \
href="https://github.com/wttw/pgsidekick">https://github.com/wttw/pgsidekick</a> \
.</p> <p>It's the first time i try to install a program and when i wrote
make , the program don't find pg_config and libpq-fe.h : <br>
</p>
<p><img src="cid:part1.EA3CBCB9.8CDD28D8@ledepartement82.fr" alt=""></p>
<p>I try with no attributes, with -I /usr/pgsql-9.5/include/ and
with -I /usr/pgsql-9.5/ . none of them works.</p>
<p>pg_config is in /usr/pgsql-9.5/bin
</p>
<p>libpq-fe.h is in /usr/pgsql-9.5/include</p>
<p>Thanks for your help<br>
</p>
<div class="moz-signature">
<table width="450" height="100" cellspacing="0" cellpadding="0"
border="0">
<tbody>
<tr valign="bottom">
<td colspan="2">
<hr size="3" noshade="noshade" color="#CCCCCC"> </td>
<td>
<br>
</td>
</tr>
<tr>
<td>
<a href="http://www.ledepartement.fr" hreflang="fr">
<img
src="http://www.ledepartement.fr/fileadmin/integration/lib/images/logo-cd82-footer.png
" alt="Logo CD82" width="150" border="0" align="left">
</a> </td>
<td>
<font size="3" face="Eras Medium ITC">
Guillaume ARNAUD
</font><br>
<font size="2" face="Eras Medium ITC">
Technicien SIG
</font><br>
<font medium="" itc »="" size=" »2 »" face=" »Eras">
Cellule SIGD
</font><br>
<font medium="" itc »="" size=" »2 »" face=" »Eras">
Direction des systèmes informatiques et de
télécommunication
</font><br>
<font medium="" itc »="" size=" »2 »" face=" »Eras">
Pôle coordination et ressources
</font><br>
<font size="2" face="Eras Medium ITC">Tél : 05 63 91 82 37
</font><br>
<a class="moz-txt-link-freetext" href="mailto:
guillaume.arnaud@ledepartement82.fr
"><font size="2">
guillaume.arnaud@ledepartement82.fr
<!--
font--></font></a><font size="2">
</font></td>
</tr>
<tr valign="top">
<td colspan="2">
<hr size="3" noshade="noshade" color="#CCCCCC">
</td>
</tr>
</tbody>
</table>
</div>
<div class="moz-cite-prefix">Le 01/04/2020 Ã 18:12, J.J. Green a
écrit :<br>
</div>
<blockquote type="cite"
cite="mid:acfaa72c-840d-1d91-95d6-fdac345410f6@gmx.com">Hi
Guillaume
<br>
<br>
> Hello, I need to refresh a materialized view in my database,
<br>
<br>
I've faced similar problems with complex derived data being too
<br>
much for a view and finding the lack of incremental update on
<br>
the standard PG materialised views means I could only update very
<br>
occasionally.
<br>
<br>
In the end, I managed to get a working solution with a "manually
<br>
materialised view", so this is just a regular table, and I have
<br>
triggers which wait for new data, and when they run they insert
<br>
the new suitably modified rows into that table.
<br>
<br>
This is _not easy_, there are lots of gotchas and edge-cases,
<br>
for my case the underlying problem was not too hard, it was just
<br>
that underlying data was too damn big.
<br>
<br>
The code was commercial, so I'm afraid I can't post it.
<br>
<br>
Bon chance !
<br>
<br>
Jim
<br>
_______________________________________________
<br>
postgis-users mailing list
<br>
<a class="moz-txt-link-abbreviated" \
href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a> <br>
<a class="moz-txt-link-freetext" \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
</blockquote>
</body>
</html>
["mhfejpdccmaakcbe.png" (image/png)]
[Attachment #9 (text/plain)]
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic