Optimizing PostGIS/Geoserver schema for huge dataset - postgresql.conf and Alter_System

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Optimizing PostGIS/Geoserver schema for huge dataset - postgresql.conf and Alter_System

James Mitchell
Andy,

Have you tweaked any of the setting in postgresql.conf or through Alter_System

See


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





_______________________________________________
postgis-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/postgis-users
Loading...