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');

See Also