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 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 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 ...Remote read only access to database for Postgres customers
Frequently customers want to connect some reporting / dashboard application like PowerBI or Tableau with our Postgres database server. By default, the bundled Postgres is configured to only listen to the local machine. We can configure to allow ...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: ...