search

gislab-npo / gislab

GIS.lab - total reduction of deployment and maintenance costs for complete free and open source geospatial infrastructure
http://gislab-npo.github.io/gislab/
GNU General Public License v3.0
40 stars 14 forks source link

GIS.lab server: PostgreSQL performace tuning #475

Closed imincik closed 7 years ago

imincik commented 8 years ago

pgtune script is not longer supported and also usable for PostgreSQL 9.4. We need to find a new way how to auto-tune PostgreSQL server. Also note, that PostgreSQL 9.4 and later use a different shared memory mechanism, so kernel settings will usually not have to be adjusted there.

At least, we can autotune 'shared_buffers' according server RAM.

See:

landam commented 7 years ago

See: https://github.com/imincik/ansible-postgresql_tune