SET_LOCATION_PERFORMANCE
Sets disk performance for the location specified.
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 be set is available. |
throughput |
Specifies the throughput for the location, which must be 1 or more. |
average_latency |
Specifies the average latency for the location. The average_latency must be 1 or more. |
Privileges
Superuser
Notes
To obtain the throughput and average latency for the location, run the MEASURE_LOCATION_PERFORMANCE() function before you attempt to set the location's performance.
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');