Managing the Repository Metadata Table Size
After installation you might need to change your TDV or Business Directory repository metadata table size. The Repository metadata table size will increase or decrease in size as metadata is added or deleted.
To manage the repository metadata table size
1. Stop the TDV repository.
2. Stop the TDV Server.
3. Locate Metadata Table Size configuration parameter.
4. Use the read only value to determine if you need to make a change to the value for the metadata database table.
5. Adjust the value of Metadata Cache Size (On Server Restart) based on the metadata table size.
6. Adjust block and segment sizes if necessary.
7. Restart the TDV repository.
8. Restart the TDV Server.
Garbage Batch Size
TDV garbage collection process makes use of a temp table in the Postgres repository, during the execution of INSERT/SELECT statements on the metadata tables.
To manage the size of the temp tables created, there is a configuration setting that can be used. This setting can be tuned in TDV Studio using the option Administration > Configuration > Debugging > Metadata > Garbage Batch Size. By default, this setting is turned off (defaults to 0). When set to a value greater than 0, the server will perform garbage collection on certain metadata tables in batches of size no greater than the specified size.