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