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
Basic Performance Issues RCA On Postgres DB Cx
Whenever cx faces slowness in PG SQL Setup, below are the first step of actions to check and proceed based on our previous performance tickets. 1. Antivirus are main cause of slowness, high CPU, and memory consumption of PGSQL in many cx tickets. ...How to Connect External Postgres
To install an external PostgreSQL server, ensure the PostgreSQL version matches the inbuilt PostgreSQL version series of the ServiceDesk Plus application. For example: If ServiceDesk Plus version is 14010 with PostgreSQL version 10.21, install an ...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 ...Upgrade Failure due to the presence of CtrlZ Failure
This issue (SD-118352) in fixed in version 14710. Post this release, these characters are handled in the migration itself. If you are planning to migrate from version less than 14610 to 14610, then you can directly migrate to 14710, to handle this ...How to resolve Connectivity issues with Postgresql Database from our product?
Log Traces Feb 20, 2024 6:40:00 PM [SYSERR] [INFO] : java.sql.SQLException: java.lang.Exception: Exception during getConnection from pool Exception occurred during get connection from datasource Nov 15, 2023 1:29:10 PM [SYSERR] [INFO] : Caused by: ...