RELEASE_SESSION_RESOURCE

Manually releases resources reserved for a particular session. Vertica automatically releases reserved resources at the end of a session.

Syntax

RELEASE_SESSION_RESOURCE ( 'name') 

Parameters

name

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

Privileges

None

Example

This example releases the memory set aside for the reserved memory pool:

=> SELECT release_session_resource('RESERVED_MEMORY');
   -[ RECORD 1 ]------------+----------------
   release_session_resource | Release success