RESERVE_SESSION_RESOURCE

Reserves memory resources from the general resource pool for the exclusive use of the Vertica backup and restore process. No other Vertica process can access reserved resources. If insufficient resources are available, Vertica queues the reservation request.

This metafunction is a session level reservation. When a session ends Vertica automatically releases any resources reserved in that session. Because the metafunction operates at the session level, the resource name does not need to be unique across multiple sessions.

You can view reserved resources by querying the SESSIONS table.

Syntax

RESERVE_SESSION_RESOURCE ( 'name',memory_kb) 

Parameters

name

[Required] Specifies the name of the resource that you want to reserve.

memory_kb
[Required] Specifies the amount of memory to allocate to the resource.

Privileges

None

Example

This example reserves 1024 kilobytes of memory for the backup and restore process:

=> SELECT reserve_session_resource('VBR_RESERVE',1024);
   -[ RECORD 1 ]------------+----------------
   reserve_session_resource | Grant succeed