Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-8.x)/ System Catalogs and System Views/ System Catalogs/ OLTP Table Compression/ GS_ILM
Updated on 2025-08-19 GMT+08:00
View PDF

GS_ILM

The GS_ILM system catalog provides the main information about the ILM policy, including the policy name, policy owner, policy type, policy ID, and policy status.

Table 1 GS_ILM columns

Name

Type

Description

pidx

integer

Policy sequence number, which is globally unique and starts with 1.

creator

oid

Policy owner.

name

name

Policy name. Currently, the policy name cannot be customized. The default name is p+pidx.

ptype

"char"

Policy type:

  • m: data movement.

flag

smallint

Value range:

  • 0: The policy is enabled.
  • 1: The policy is disabled.
Parent topic: OLTP Table Compression