Performance related issue due to missing postgres_ext.conf file missing.

Performance related issue due to missing postgres_ext.conf file missing.


In our Application, while a user faces a performance issue, we usually perform java tuning and Postgres tuning for Postgres users. But please also check if the file given in the below directory is present. 

SupportCenter/pgsql/ext_conf ----> postgres_ext.conf

ServiceDeskPlus-MSP\pgsql\ext_conf ----> postgres_ext.conf


If the file is not present, then the Application defaults (hard coded in the Application) to the lowest parameters which would only make the performance of the Application worsen. 

Please make sure those to add that detail to be checked while debugging a performance issue. 



                    New to ADSelfService Plus?

                      • Related Articles

                      • How to address Performance issue ?

                        Application will face the performance issue because of couple of reasons. 1. System requirements are not met: Refer this link to ensure the specifications are met as per the standards. 2. Application architecture should be 64-bit for better ...
                      • How to enable Performance monitoring tool ?

                        To analyze Performance issues, logs and tuning alone won't be sufficient. Hence, we need to follow a few steps to enable the Performance Monitoring tool, which will monitor the application's performance and automatically collects the data when the ...
                      • Performance Debug

                        For Performance/slowness issues instead of taking Threaddump manually or instead of invoking PerformanceTool make use of the below URL when the issue occurs, http://servername:portnumber/servlet/PerformanceDebug The above URL works even when the ...
                      • SDP MSP solution for postgres 11 upgrade issues

                        When ServiceDesk Plus MSP is upgraded to 14300 or later, postgres is also upgraded to 11.17. If you are using bundled postgres, data migration through pgdump and restore mechanism also happens. To ensure efficiency in Postgres 11.17, make sure your ...
                      • Subject Alternative Name missing Error under Browser (SAN Missing)

                        Error : Solution: Please find below the commands that can be used to create the keystore and corresponding CSR request with SAN included: Keystore creation:  keytool -genkey -alias <your_alias_name> or [Domain Name] -keyalg RSA -keysize 2048 -sigalg ...