SET_LOCATION_PERFORMANCE
Sets disk performance for a storage location.
Sets disk performance for a storage location.
Note
Before calling this function, call MEASURE_LOCATION_PERFORMANCE to obtain the location's throughput and average latency .This is a meta-function. You must call meta-functions in a top-level SELECT statement.
Behavior type
VolatileSyntax
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
Examples
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');