Highlighted
Absent Member.. Absent Member..
Absent Member..
299 views

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

0 Likes
2 Replies
Highlighted
Honored Contributor.
Honored Contributor.

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
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

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

 

Regards,

K

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.