SET_LOCATION_PERFORMANCE
Sets disk performance for a storage location.
Before calling this function, call MEASURE_LOCATION_PERFORMANCE to obtain the location's throughput and average latency .
Syntax
SET_LOCATION_PERFORMANCE ( 'path', 'node' , 'throughput', 'average‑latency')
Parameters
| path |
Specifies where the storage location to set is mounted. |
| node |
Specifies the Vertica node where the location to set is available. |
| throughput |
Specifies the throughput for the location, set to a value ≥1. |
| average‑latency |
Specifies the average latency for the location, set to a value ≥1. |
Privileges
Superuser
Example
The following example sets the performance of a storage location on node2 to a throughput of 122 megabytes per second and a latency of 140 seeks per second.
=> SELECT SET_LOCATION_PERFORMANCE('/secondVerticaStorageLocation/','node2','122','140');