Space usage in DataCollector directory

Hi,

You can control the size restraint (memory and disk space in kilobytes) for the specified Data Collector table on all nodes via the SET_DATA_COLLECTOR_POLICY function.

See:
https://my.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/VerticaFunctions/DataCollection/SET_DATA_COLLECTOR_POLICY.htm

You can see all of the DC function here:
https://my.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/VerticaFunctions/DataCollection/DataCollectorFunctions.htm

Here is a quick example of using the CLEAR_DATA_COLLECTOR function ...

[dbadmin@s18384357 DataCollector]$ du -h
132M     .
[dbadmin@s18384357 DataCollector]$ vsql -c "SELECT clear_data_collector();"
 clear_data_collector
----------------------
 CLEAR
(1 row)

[dbadmin@s18384357 DataCollector]$ du -h
2.7M    .

That worked...
[dbadmin@localhost DataCollector]$ du -sh .
38.2G .
[dbadmin@localhost DataCollector]$ vsql -c "SELECT clear_data_collector();"
Password:

clear_data_collector

CLEAR
(1 row)

[dbadmin@localhost DataCollector]$ du -sh .
2.7M .

Nice! You might want to alter the data retention policy of particular DC tables.

See:
https://my.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/AdministratorsGuide/Monitoring/Vertica/ConfiguringDataRetentionPolicies.htm