UCMDB and UD Practitioners Forum (Previously CMS)
Showing results for 
Search instead for 
Do you mean 

Postgre sql help

Frequent Advisor

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
Trusted 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.
Frequent Advisor

Re: Postgre sql help

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

 

Regards,

K

//Add this to "OnDomLoad" event