[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