AnsweredAssumed Answered

Postgres Tuning

Question asked by andy.erskine on Jul 16, 2015
Latest reply on Jul 16, 2015 by Hallett_German

Hi I'd like to open a discussion regarding Postgres and Tuning - what advise is out there regarding Tuning the DB ?

 

For example i have a scenario with 2 x MOM (1 x DR) and 9 collectors (8 + 1 TIM being fed from 2 x MPM's)

 

APM 9.7 Postgres currently sitting at 146GB.

 

Reading the Wiki Process SAML Authentication there doesn't seem to be a great deal covering it,

 

i've just found another useful doc here :

 

https://communities.ca.com/message/100453734#100453734

 

and that recommends the following but its a few years old for version 9.1

 

DB Tuning. Set the following in the psql config at :

$PGHOME/database/data/postgresql.conf o max_connections=1000

o effective_cache_size = 1GB o

These property changes will require a restart of postgres

 

If i use a tool such as http://pgtune.leopard.in.ua/

 

It gives me recommendations as such :

postres_params.JPG

 

Compare that with what my postgres db is currently set as (OOB) for these values then it certainly appears that some tuning would be advised :

 

max_connections = 125

shared_buffers = 32MB

#effective_cache_size = 128MB

work_mem = 64MB

maintenance_work_mem = 128MB

checkpoint_segments = 8

#checkpoint_completion_target = 0.5

wal_buffers = 1024kB

#default_statistics_target = 100

Outcomes