ETC postgres database maintenance

[Lee Barton]

​Hi
Our postgres db for Enterprise Team Center is getting very large.. is there any procedures available or best practices around pruning the data in it, or do I just have to keep expanding the filesystem further when it reaches 90%?
I searched and could not find any docs here or on google around whether this is data it is safe to prune, or procedures around it.

Thanks
Lee

[Haruhiko Davis]

Hey Lee,
Sounds like DB Vacuum is not running. Check with your CSA or open a ticket.

------------------------------
Custom Solution Architect
Broadcom
------------------------------

[Gnanawathy Hareendran]

Hi Lee, 

Here are some KBs on APM PostgreSQl DB maintenance:

1. Manually execute a 'vacuum' process using PGAdmin tool.
https://knowledge.broadcom.com/external/article?articleId=9486

2.How can we optimize our APM database that is growing larger very quickly?
https://knowledge.broadcom.com/external/article?articleId=16443

3. APM database is growing fast - too many appmap_states tables. Is there a property to prune those tables
https://knowledge.broadcom.com/external/article?articleId=4232

4. How can we tune Postgres database for Linux box with 16GB Memory?
https://knowledge.broadcom.com/external/article?articleId=16381


Hope these help.

Thanks,
Yanna.

[Jörg Mertin]

In case you have a standard PostgreSQL installation, you can also install the health-check scripts (https://github.com/CA-APM/cem-healthcheck-scripts)
and execute the PSQL log collection. It will drop a report on the current DB utilization.

Just unpack in /tmp (directory you are allowed to write and execute). It will try to detect the location of the PostgreSQL installation and collect the data.

 

------------------------------
Customer Solution Engineering
Broadcom Inc.
------------------------------