We have a problem about postgresql connection. When we connect and generate/mask data on postgresql database from portal the connection transaction remains open. It causes performance problem(high cpu usage) on database. After the masking/generation process done, this transaction must be closed automatically. Also, we were not having this problem on DB2 or MsSQL.
Release : 4.9.1
Component : CA Test Data Manager
By design, we use connection pooling with the following entry in application.properties (located at <TDM_HOM>/conf directory). This connection pool is to improve the application performance.
As explained in postgres forum, these idle connections will not have impact on Memory and CPU. If you want to reduce these the connections, modify below properties in application.properties file and restart the TDM portal service.
# Connection pool properties (per service) for the tomcat connection pool manager