ALTER_LOCATION_SIZE
Eon Mode only
Resizes the depot on one node, all nodes in a subcluster, or all nodes in the database.
Reducing the size of the depot is liable to increase contention over depot usage and require frequent evictions. This behavior can increase the number of queries and load operations that are routed to communal storage for processing, which can incur slower performance and increased access charges.
Syntax
ALTER_LOCATION_SIZE( 'location', '[target]', 'size')
Parameters
location
|
Specifies the location to resize, one of the following:
|
target
|
The node or nodes on which to change the depot, one of the following:
|
size
|
Valid only if the storage location usage type is set to You can specify size in two ways:
The depot size cannot exceed 80 percent of the file system disk space where the depot is stored. If you specify a value that is too large, Vertica issues a warning and automatically changes the value to 80 percent of the file system size. |
Privileges
Examples
Increase depot size on all nodes to 80 percent of file system:
=> SELECT node_name, location_label, location_path, max_size, disk_percent FROM storage_locations WHERE location_usage = 'DEPOT' ORDER BY node_name; node_name | location_label | location_path | max_size | disk_percent ------------------+-----------------+-------------------------+-------------+-------------- v_vmart_node0001 | auto-data-depot | /home/dbadmin/verticadb | 36060108800 | 70% v_vmart_node0002 | auto-data-depot | /home/dbadmin/verticadb | 36059377664 | 70% v_vmart_node0003 | auto-data-depot | /home/dbadmin/verticadb | 36060108800 | 70% (3 rows) => SELECT alter_location_size('depot', '','80%'); alter_location_size --------------------- depotSize changed. (1 row) => SELECT node_name, location_label, location_path, max_size, disk_percent FROM storage_locations WHERE location_usage = 'DEPOT' ORDER BY node_name; node_name | location_label | location_path | max_size | disk_percent ------------------+-----------------+-------------------------+-------------+-------------- v_vmart_node0001 | auto-data-depot | /home/dbadmin/verticadb | 41211552768 | 80% v_vmart_node0002 | auto-data-depot | /home/dbadmin/verticadb | 41210717184 | 80% v_vmart_node0003 | auto-data-depot | /home/dbadmin/verticadb | 41211552768 | 80% (3 rows)
Change the depot size to 75% of the filesystem size for all nodes in the analytics subcluster:
=> SELECT subcluster_name, subclusters.node_name, storage_locations.max_size, storage_locations.disk_percent FROM subclusters INNER JOIN storage_locations ON subclusters.node_name = storage_locations.node_name WHERE storage_locations.location_usage='DEPOT'; subcluster_name | node_name | max_size | disk_percent --------------------+----------------------+---------------------------- default_subcluster | v_verticadb_node0001 | 25264737485 | 60% default_subcluster | v_verticadb_node0002 | 25264737485 | 60% default_subcluster | v_verticadb_node0003 | 25264737485 | 60% analytics | v_verticadb_node0004 | 25264737485 | 60% analytics | v_verticadb_node0005 | 25264737485 | 60% analytics | v_verticadb_node0006 | 25264737485 | 60% analytics | v_verticadb_node0007 | 25264737485 | 60% analytics | v_verticadb_node0008 | 25264737485 | 60% analytics | v_verticadb_node0009 | 25264737485 | 60% (9 rows) => SELECT ALTER_LOCATION_SIZE('depot','analytics','75%'); ALTER_LOCATION_SIZE --------------------- depotSize changed. (1 row) => SELECT subcluster_name, subclusters.node_name, storage_locations.max_size, storage_locations.disk_percent FROM subclusters INNER JOIN storage_locations ON subclusters.node_name = storage_locations.node_name WHERE storage_locations.location_usage='DEPOT'; subcluster_name | node_name | max_size | disk_percent --------------------+----------------------+---------------------------- default_subcluster | v_verticadb_node0001 | 25264737485 | 60% default_subcluster | v_verticadb_node0002 | 25264737485 | 60% default_subcluster | v_verticadb_node0003 | 25264737485 | 60% analytics | v_verticadb_node0004 | 31580921856 | 75% analytics | v_verticadb_node0005 | 31580921856 | 75% analytics | v_verticadb_node0006 | 31580921856 | 75% analytics | v_verticadb_node0007 | 31580921856 | 75% analytics | v_verticadb_node0008 | 31580921856 | 75% analytics | v_verticadb_node0009 | 31580921856 | 75% (9 rows)