I have an entire Spain agronomic parcels layer in a PostgreDB and I´m triying to serve it through GeoServer.
I split by villages to improve the speed of the petitions, but how can I serve all the territory with one client petition (and quickly)?
My machine is an ubuntu 18 google machine. In postgres, "spain table" is divided by village (+5000 tables). All of these are in geoserver gruped by province (state) (50 groups). My first idea was group the 50 groups in one and call it, but is very low (minutes to load in the client web.
How can I do that?
I'm going to try with geowebcache but I'm not sure it can pregenerate the enormous amount of tiles.