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 [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
