[postgis-users] Optimizing PostGIS/Geoserver schema for huge dataset - postgresql.conf and Alter_System
James Mitchell
jgm72 at uw.edu
Sat Apr 1 14:10:15 PDT 2017
Andy,
Have you tweaked any of the setting in postgresql.conf or through
Alter_System
See
https://wiki.postgresql.org/wiki/Performance_Optimization
for a list of suggestions and links to other websites.
I achieved orders of magnitude increases in performance running postgis
queries by changing just a few settings such as work_mem and shared_buffers.
Jim
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20170401/5d92f158/attachment.html>
More information about the postgis-users
mailing list