GARRAY_PAGE_SPLIT_PAD_PERCENT Option

Determines per-page fill factor during page splits on the garray and specifies the percent of space on each HG garray page to reserve for future incremental inserts.

Allowed Values

0 – 100

Default

25

Scope

DBA permissions are not required to set this option. Can be set temporary for an individual connection or for the PUBLIC group. Takes effect immediately.

Description

Splits of a garray page try to leave that percentage empty. This space is used for rows added to new index groups.

An HG index can reserve storage at the page level that can be allocated to new groups when additional rows are inserted. Reserving space consumes additional disk space, but can help the performance of incremental inserts into the HG index.

If future plans include incremental inserts into an HG index, and the new rows do not have values that are already present in the index, a nonzero value for GARRAY_PAGE_SPLIT_PAD_PERCENT could improve incremental insert performance.

If you do not plan to incrementally update the index, you can reduce the values of this option to save disk space.

Related reference
GARRAY_FILL_FACTOR_PERCENT Option