Tuning the PostgreSQL Database
From Observer GigaFlow Support | VIAVI Solutions Inc.
Revision as of 08:36, 13 October 2016 by Kevin Wilkie (Talk | contribs)
Tuning of postgres is done via the postgresql.conf file shared_buffers=1/4 of the available memory
effective_cache_size = 1/2 of available memory
autovacuum_max_workers = 1 checkpoint_completion_target = 0.9 checkpoint_segments = 32 effective_cache_size = 1GB log_min_duration_statement = 5000 shared_buffers = 500MB synchronous_commit = off work_mem = 4MB wal_buffers= 10MB commit_delay 10 max_locks_per_transaction=3000 work_mem=4
For 2GB system