UCMDB and UD Practitioners Forum (Previously CMS)
cancel

Postgre sql help

Highlighted
Kunjappy
Respected Contributor.

Postgre sql help

Hi,

can someone guide me where i can set these values in postgre sql? we have 8gb ram for the probe server. so what could be the best settings and where to update this? in which file i need to update and where is the location? If i set these values dose it improve the discovery performance and integration push? 

shared_buffers = 
effective_cache_size = 
work_mem = 
maintenance_work_mem =

Regards,

K

2 REPLIES
NikolaTodorov
Honored Contributor.

Re: Postgre sql help

Hello Kunjappy,

Those settings can be found there: <DataFlowProbe>\pgsql\data\postgresql.conf
Please do not change the settings there in case it is not necessary. There should be better ways to improve the integration jobs performance by using some general best practices.

Best Regards,
Nikola

------------------------
Nikola Todorov
HPE Software Support

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Kunjappy
Respected Contributor.

Re: Postgre sql help

Thanks Nikola. DO you have any document for the best practice to improve integration and discovery jobes?

 

Regards,

K