Hi,
Recently we upgraded CMDBuild from V3.3 to 3.4.2. Simultaneously we upgraded our system.
Now system configuration is:
OS: UBUNTU 22.04
PostgreSQL : 12
Apache Tomcat 9.0.53
JDK 17
RAM: 12 Gig (without BIM server)
Every thing is going well but there is a bad latency in some search queries. For example searching for a word in a superclass which contains 20 classes with 40 thousands active rows takes about 1 minutes.
We increased java heap size memory up to 3 GB but it didn’t resolve.
Does anyone have a solution or suggestion?
1 Like
try to use vacuumdb