Client connection defaults/statement behavior v15

Suggest edits

These configuration parameters affect statement behavior.

default_heap_fillfactor

Parameter type: Integer

Default value: 100

Range: 10 to 100

Minimum scope of effect: Per session

When value changes take effect: Immediate

Required authorization to activate: Session user

Sets the fill factor for a table when the FILLFACTOR storage parameter is omitted from a CREATE TABLE command.

The fill factor for a table is a percentage from 10 to 100, where 100 is complete packing. When you specify a smaller fill factor, INSERT operations pack table pages only to the indicated percentage. The remaining space on each page is reserved for updating rows on that page. This approach gives UPDATE a chance to place the updated copy of a row on the same page as the original, which is more efficient than placing it on a different page.

For a table whose entries are never updated, complete packing is the best choice. In heavily updated tables, use smaller fill factors.

edb_data_redaction

Parameter type: Boolean

Default value: true

Range: {true | false}

Minimum scope of effect: Per session

When value changes take effect: Immediate

Required authorization to activate: Session user

Data redaction is the support of policies to limit the exposure of certain sensitive data to certain users by altering the displayed information.

When set to TRUE, the data redaction is applied to all users except for superusers and the table owner:

  • Superusers and table owner bypass data redaction.
  • All other users get the redaction policy applied and see the reformatted data.

When set to FALSE, the following occurs:

  • Superusers and table owner still bypass data redaction.
  • All other users get an error.

For information on data redaction, see EDB Postgres Advanced Server Security Features.

← Prev

Client connection defaults/locale and formatting

Next →

Client connection defaults/other defaults