Parsis, according https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server shared_buffers "a reasonable starting value for shared_buffers is 1/4 of the memory in your system". So, the starting value for your 61GB RAM is 1525000 Megabyte. Make sure you have PostgreSQL >= 9.4, because < 9.4 requires some kernel settings adjustment.
For work_mem, you must evaluate EXPLAIN ANALYSE and consider the number of simultaneous users. Em qua, 6 de mar de 2019 às 11:32, parsis presswala < [email protected]> escreveu: > I have improve Postgresql configuration shared_buffer = 20000 MB and > work_mem = 500 MB. > Is this configuration fine or I need to improve more? > > >
_______________________________________________ mapserver-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/mapserver-users
