Product DocumentationAppearance
Configuration Parameters
The following table shows the subset of configuration parameters that are typically exposed in a production environment. If Yellowbrick Customer Support has worked with you to modify other parameters, the current values for those parameters are also displayed when you run the SHOW ALL command.
For related information about setting these parameters, see the following commands: ALTER SYSTEM, SET, SET ROLE, and RESET.
| Parameter Name | Default Value | Modifiable | Description | See Also |
|---|---|---|---|---|
application_name | ybsql (for example) | Yes | Application name to be reported in statistics and logs. | sys.session, sys.log_query |
block_size | 32768 | No | Size of a block on disk; not configurable in Yellowbrick. | |
bytea_output | hex | No | Required for pgAdmin compatibility; controls how the bytea type is sent to the client. | |
client_encoding | UTF8 | Yes | Client's character set encoding. | Creating Databases |
client_min_messages | WARNING | Yes | Verbosity of errors returned to the client: debug5, debug4, debug3, debug2, debug1, log, notice, warning, info, error. | |
DateStyle | ISO, MDY | Yes | Display format for date and time values. | ybload Date Formats, DATE |
enable_alternative_round | OFF | Yes | Translation of ROUND to ROUND_VAR, which allows a non-constant second argument. | ROUND, ROUND_VAR |
enable_query_trace | OFF | Yes | Enable full query statistics to be sent from the worker nodes. Full statistics contain data from each node and each thread. Setting this parameter to on may be useful prior to running EXPLAIN (ANALYZE) on queries. | EXPLAIN |
enable_silent_coerce | OFF | Yes | Whether to down-cast and truncate character strings (for example,allowing a 3-character string to be inserted into a 2-character column). | Implicit Casting |
extra_float_digits | 0 | Yes | Number of digits displayed for floating-point values. | extra_float_digits |
idle_in_transaction_session_timeout | 10 minutes (600000 ms) | Yes | Maximum allowed duration of any idling transaction. | Managing Idle SessionsRunning show idle_session_timeout or show idle_in_transaction_session_timeout as a superuser will always return unlimited (0), which is the superuser's setting, not the default setting for the cluster. |
idle_session_timeout | 60 minutes (3600000 ms) | Yes | Maximum allowed session duration after any statement. | Managing Idle Sessions |
lc_collate, lc_ctype, lc_time | C (for all three) | No | Collation order locale; character classification and case conversion locale; and locale for formatting date and time values. | Creating Databases |
listen_addresses | * | Yes; server restart required. | Host name or IP address(es) to listen to. | |
log_timezone | UTC | No | Time zone to use in log messages. | |
max_connections, max_user_connections | 2300, 2000 | Yes; server restart required. | Maximum number of concurrent connections and concurrent user connections. | Database Limits |
max_index_keys | 32 | No | Maximum number of index keys. | |
max_wal_size, wal_block_size, wal_level | 16GB, 8192, minimal | No | Write-ahead log settings for PostgreSQL compatibility; not configurable in Yellowbrick. | |
port | 5432 | Yes; server restart required. | Default port for database connections | |
search_path | "$user", public | Yes | Schema search order for names that are not schema-qualified. | CURRENT_SCHEMA |
server_encoding | LATIN9 or UTF8; depends on database. | No | Server (database) character set encoding. | Creating Databases. |
ssl | ON | Yes; server restart required. | Whether SSL connections are enabled. | SSL/TLS Overview |
ssl_ca_dir,ssl_cert_file,ssl_ciphers, ssl_key_file | /mnt/ybdata/certs/trust-database, /mnt/ybdata/certs/ybd.crt, ECDHE:!3DES:!DES:!NULL:!RC4, /mnt/ybdata/certs/ybd.key | Yes; server restart required. | Location of the SSL certificate authority directory; location of the SSL server certificate file; list of allowed SSL ciphers; location of the SSL server private key file. | |
ssl_prefer_server_ciphers | ON | Default recommended; server restart required. | Priority to server cipher suite order; can be set to off for backward compatibility with very old clients, but the default is recommended. | |
statement_timeout | 0 | Yes | Maximum allowed duration, in milliseconds, of any statement. | Canceling Queries |
tcp_keepalives_count, tcp_keepalives_idle, tcp_keepalives_interval | 10, 10, 1 | No | Maximum number of TCP keep-alive retransmits, time between issuing keep-alives, and time between keep-alive retransmits. | |
timezone | UTC | Yes | Time zone for displaying and interpreting time stamps. | TIMESTAMP WITH TIME ZONE, ybload Timestamp Formats |
transaction_isolation | READ COMMITTED | No; no other isolation level is currently supported. | Current transaction's isolation level. | BEGIN |
yb_last_execid | No default | No | Execution ID of the last backend query run in this session. | |
yb_server_version | 5.3.0 (for example, release-specific) | No | Yellowbrick database server version. | |
yb_server_version_num | 50300 (for example, release-specific) | No | Yellowbrick database server version as an integer. | |
ybd_analyze_after_loads | ||||
ybd_analyze_after_writes | ||||
ybd_query_tags | No default | Yes | Optional query tags to be stored in query history. | Using Query Tags |
ybd_secrets_manager | k8ss | Yes | Setting that enables SQL encryption functions. | Encrypting Sensitive Data |
Parent topic:SHOW