Help Center/ GaussDB/ Centralized_8.x/ System Catalogs and System Views/ System Catalogs/ OLTP Table Compression/ GS_ILM_POLICY
Updated on 2024-06-03 GMT+08:00
View PDF

GS_ILM_POLICY

The GS_ILM_POLICY system catalog records policy action types and judgment conditions.

Table 1 GS_ILM_POLICY columns

Name

Type

Description

pidx

integer

Policy ID.

action

"char"

Policy action. Only compression ('c') is supported.

ctype

"char"

Compression type. Only advanced row compression ('a') is supported.

condition

"char"

Condition type. Only LAST MODIFICATION('m') is supported.

days

smallint

Number of judgment days.

scope

"char"

Policy scope. Only row ('r') is supported.

predicate

pg_node_tree

Policy row-level expression.
Parent topic: OLTP Table Compression