Client connection defaults/statement behavior v15
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.
- On this page
- default_heap_fillfactor
- edb_data_redaction