search cancel

Enterprise Team Center Database Maintenance

book

Article ID: 189932

calendar_today

Updated On:

Products

CA Application Performance Management Agent (APM / Wily / Introscope) CA Application Performance Management (APM / Wily / Introscope) INTROSCOPE DX Application Performance Management

Issue/Introduction

ETC server PostgresSQL Database seems to be growing quickly. 
Is there anything that can be done to prune it?  

Environment

Release : 10.7.0

Component : ETC PostgreSQL Database

Cause

DB  Vacuum may not be running

Resolution

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