I have started using GeoServer and PostgreSQL combination to render polygons (more than 4000) on Google Map. Everything seems to be fine.

However, when I zoom the map, layers are redrawn very slowly on browser.
These polygons are not fixed. I get information about which polygons need to be displayed from a web page and then from PostgreSQL view. Therefore I have passed viewParams in WMS service of GeoServer.
I use GeoWebCache.

But the problem I described above does not solve from GeoWebCache. Is there anything that I can try to improve performance?


Set GeoServer logging to "GEOTOOLS_DEVELOPER", check the query actually done in the logs, and run an "explain" of that query in PostgreSQL to see where the performance issues are. References:

Once you have figured out what's slow, change your view definition accordingly (GeoServer adds bits around your query, but you have no control over them).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.