[postgis-users] Refresh materialized view only when it's necessary

Guillaume ARNAUD guillaume.arnaud at ledepartement82.fr
Thu Apr 2 06:19:12 PDT 2020

Hi again,

i see 
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 at 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 at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200402/62c1a139/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mhfejpdccmaakcbe.png
Type: image/png
Size: 112007 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200402/62c1a139/attachment.png>

More information about the postgis-users mailing list