Ungrouped v10
Configuration parameters in this section apply to Advanced Server only and are for a specific, limited purpose.
nls_length_semantics
Parameter Type: Enum
Default Value: byte
Range: {byte | char}
Minimum Scope of Effect: Per session
When Value Changes Take Effect: Immediate
Required Authorization to Activate: Superuser
This parameter has no effect in Advanced Server.
For example, the form of the ALTER SESSION command is accepted in Advanced Server without throwing a syntax error, but does not alter the session environment:
ALTER SESSION SET nls_length_semantics = char;
Note
Since the setting of this parameter has no effect on the server environment, it does not appear in the system view pg_settings.
query_rewrite_enabled
Parameter Type: Enum
Default Value: false
Range: {true | false | force}
Minimum Scope of Effect: Per session
When Value Changes Take Effect: Immediate
Required Authorization to Activate: Session user
This parameter has no effect in Advanced Server.
For example, the following form of the ALTER SESSION command is accepted in Advanced Server without throwing a syntax error, but does not alter the session environment:
ALTER SESSION SET query_rewrite_enabled = force;
Note
Since the setting of this parameter has no effect on the server environment, it does not appear in the system view pg_settings.
query_rewrite_integrity
Parameter Type: Enum
Default Value: enforced
Range: {enforced | trusted | stale_tolerated}
Minimum Scope of Effect: Per session
When Value Changes Take Effect: Immediate
Required Authorization to Activate: Superuser
This parameter has no effect in Advanced Server.
For example, the following form of the ALTER SESSION command is accepted in Advanced Server without throwing a syntax error, but does not alter the session environment:
ALTER SESSION SET query_rewrite_integrity = stale_tolerated;
Note
Since the setting of this parameter has no effect on the server environment, it does not appear in the system view pg_settings.
timed_statistics
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
Controls the collection of timing data for the Dynamic Runtime Instrumentation Tools Architecture (DRITA) feature. When set to on, timing data is collected.
Note
When Advanced Server is installed, the postgresql.conf file contains an explicit entry setting timed_statistics to off. If this entry is commented out letting timed_statistics to default, and the configuration file is reloaded, timed statistics collection would be turned on.