DX Application Performance Management

  • 1.  Postgres Tuning

    Posted Jul 15, 2015 09:29 PM

    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



  • 2.  Re: Postgres Tuning

    Broadcom Employee
    Posted Jul 15, 2015 10:50 PM

    Hi Andy,

     

    if you have 16 GB available it certainly can't hurt to increase those setttings. You won't need more connections as only the EMs connect to the APM DB.

     

    Are you facing any performance problems with the DB?

     

    I could send you a health check script to analyze the DB and explain what the 146 GB are used for.

     

    Send me your email and I'll drop you the scripts.

     

    Ciao,

    Guenter



  • 3.  Re: Postgres Tuning

    Posted Jul 15, 2015 11:10 PM

    Thanks Guenter will send email for scripts.

     

    We are having performance issues when running analysis eg defects in CEM - however these may be related to some aggregation issues i am working with CA support on currently.

     

    We are having some downtime today so i will look at increasing some of the settings. thanks.



  • 4.  Re: Postgres Tuning

    Broadcom Employee
    Posted Jul 16, 2015 06:46 AM

    Dear Andy:

         When dealing with APM Database, there are two sides to consider

         - What I am sending into the database (low defect thresholds generating too many defects, unnecessary users and user groups etc.)

        - How am I maintaining the database

     

    Database Maintenance

     

     

     

    The above plus the general Postgres settings are all part of a good database optimization

     

     

    Thanks

    Hal German

    APM Support