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 :
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