Supported System Variables
Readyset currently supports setting the following system variables to any value.
allow_system_table_mods(opens in a new tab)application_name(opens in a new tab)archive_command(opens in a new tab)archive_mode(opens in a new tab)archive_timeout(opens in a new tab)authentication_timeout(opens in a new tab)autovacuum_analyze_scale_factor(opens in a new tab)autovacuum_analyze_threshold(opens in a new tab)autovacuum_freeze_max_age(opens in a new tab)autovacuum_max_workers(opens in a new tab)autovacuum_multixact_freeze_max_age(opens in a new tab)autovacuum_naptime(opens in a new tab)autovacuum_vacuum_cost_delay(opens in a new tab)autovacuum_vacuum_cost_limit(opens in a new tab)autovacuum_vacuum_scale_factor(opens in a new tab)autovacuum_vacuum_threshold(opens in a new tab)autovacuum_work_mem(opens in a new tab)autovacuum(opens in a new tab)backend_flush_after(opens in a new tab)bgwriter_delay(opens in a new tab)bgwriter_flush_after(opens in a new tab)bgwriter_lru_maxpages(opens in a new tab)bgwriter_lru_multiplier(opens in a new tab)block_size(opens in a new tab)bonjour_name(opens in a new tab)bonjour(opens in a new tab)check_function_bodies(opens in a new tab)checkpoint_completion_target(opens in a new tab)checkpoint_flush_after(opens in a new tab)checkpoint_timeout(opens in a new tab)checkpoint_warning(opens in a new tab)client_min_messages(opens in a new tab)cluster_name(opens in a new tab)commit_delay(opens in a new tab)commit_siblings(opens in a new tab)config_file(opens in a new tab)constraint_exclusion(opens in a new tab)cpu_index_tuple_cost(opens in a new tab)cpu_operator_cost(opens in a new tab)cpu_tuple_cost(opens in a new tab)cursor_tuple_fraction(opens in a new tab)data_checksums(opens in a new tab)data_directory(opens in a new tab)db_user_namespace(opens in a new tab)deadlock_timeout(opens in a new tab)debug_assertions(opens in a new tab)debug_pretty_print(opens in a new tab)debug_print_parse(opens in a new tab)debug_print_plan(opens in a new tab)debug_print_rewritten(opens in a new tab)default_statistics_target(opens in a new tab)default_tablespace(opens in a new tab)default_text_search_config(opens in a new tab)default_transaction_deferrable(opens in a new tab)default_transaction_isolation(opens in a new tab)default_transaction_read_only(opens in a new tab)default_with_oids(opens in a new tab)dynamic_library_path(opens in a new tab)dynamic_shared_memory_type(opens in a new tab)effective_cache_size(opens in a new tab)effective_io_concurrency(opens in a new tab)enable_bitmapscan(opens in a new tab)enable_gathermerge(opens in a new tab)enable_hashagg(opens in a new tab)enable_hashjoin(opens in a new tab)enable_indexonlyscan(opens in a new tab)enable_indexscan(opens in a new tab)enable_material(opens in a new tab)enable_mergejoin(opens in a new tab)enable_nestloop(opens in a new tab)enable_seqscan(opens in a new tab)enable_sort(opens in a new tab)enable_tidscan(opens in a new tab)escape_string_warning(opens in a new tab)event_source(opens in a new tab)exit_on_error(opens in a new tab)external_pid_file(opens in a new tab)force_parallel_mode(opens in a new tab)from_collapse_limit(opens in a new tab)fsync(opens in a new tab)full_page_writes(opens in a new tab)geqo_effort(opens in a new tab)geqo_generations(opens in a new tab)geqo_pool_size(opens in a new tab)geqo_seed(opens in a new tab)geqo_selection_bias(opens in a new tab)geqo_threshold(opens in a new tab)geqo(opens in a new tab)gin_fuzzy_search_limit(opens in a new tab)gin_pending_list_limit(opens in a new tab)hba_file(opens in a new tab)hot_standby_feedback(opens in a new tab)hot_standby(opens in a new tab)huge_pages(opens in a new tab)ident_file(opens in a new tab)idle_in_transaction_session_timeout(opens in a new tab)ignore_checksum_failure(opens in a new tab)ignore_system_indexes(opens in a new tab)integer_datetimes(opens in a new tab)join_collapse_limit(opens in a new tab)krb_caseins_users(opens in a new tab)krb_server_keyfile(opens in a new tab)listen_addresses(opens in a new tab)lo_compat_privileges(opens in a new tab)local_preload_libraries(opens in a new tab)lock_timeout(opens in a new tab)log_autovacuum_min_duration(opens in a new tab)log_checkpoints(opens in a new tab)log_connections(opens in a new tab)log_destination(opens in a new tab)log_directory(opens in a new tab)log_disconnections(opens in a new tab)log_duration(opens in a new tab)log_error_verbosity(opens in a new tab)log_executor_stats(opens in a new tab)log_file_mode(opens in a new tab)log_filename(opens in a new tab)log_hostname(opens in a new tab)log_line_prefix(opens in a new tab)log_lock_waits(opens in a new tab)log_min_duration_statement(opens in a new tab)log_min_error_statement(opens in a new tab)log_min_messages(opens in a new tab)log_parser_stats(opens in a new tab)log_planner_stats(opens in a new tab)log_replication_commands(opens in a new tab)log_rotation_age(opens in a new tab)log_rotation_size(opens in a new tab)log_statement_stats(opens in a new tab)log_statement(opens in a new tab)log_temp_files(opens in a new tab)log_timezone(opens in a new tab)log_truncate_on_rotation(opens in a new tab)logging_collector(opens in a new tab)maintenance_work_mem(opens in a new tab)max_connections(opens in a new tab)max_files_per_process(opens in a new tab)max_function_args(opens in a new tab)max_identifier_length(opens in a new tab)max_index_keys(opens in a new tab)max_locks_per_transaction(opens in a new tab)max_logical_replication_workers(opens in a new tab)max_parallel_workers_per_gather(opens in a new tab)max_parallel_workers(opens in a new tab)max_pred_locks_per_page(opens in a new tab)max_pred_locks_per_relation(opens in a new tab)max_pred_locks_per_transaction(opens in a new tab)max_prepared_transactions(opens in a new tab)max_replication_slots(opens in a new tab)max_stack_depth(opens in a new tab)max_standby_archive_delay(opens in a new tab)max_standby_streaming_delay(opens in a new tab)max_sync_workers_per_subscription(opens in a new tab)max_wal_senders(opens in a new tab)max_wal_size(opens in a new tab)max_worker_processes(opens in a new tab)min_parallel_index_scan_size(opens in a new tab)min_parallel_table_scan_size(opens in a new tab)min_wal_size(opens in a new tab)old_snapshot_threshold(opens in a new tab)operator_precedence_warning(opens in a new tab)parallel_setup_cost(opens in a new tab)parallel_tuple_cost(opens in a new tab)password_encryption(opens in a new tab)port(opens in a new tab)post_auth_delay(opens in a new tab)pre_auth_delay(opens in a new tab)quote_all_identifiers(opens in a new tab)random_page_cost(opens in a new tab)replacement_sort_tuples(opens in a new tab)restart_after_crash(opens in a new tab)row_security(opens in a new tab)segment_size(opens in a new tab)seq_page_cost(opens in a new tab)server_encoding(opens in a new tab)server_version_num(opens in a new tab)server_version(opens in a new tab)session_preload_libraries(opens in a new tab)session_replication_role(opens in a new tab)shared_buffers(opens in a new tab)shared_preload_libraries(opens in a new tab)ssl_ca_file(opens in a new tab)ssl_cert_file(opens in a new tab)ssl_ciphers(opens in a new tab)ssl_crl_file(opens in a new tab)ssl_dh_params_file(opens in a new tab)ssl_ecdh_curve(opens in a new tab)ssl_key_file(opens in a new tab)ssl_prefer_server_ciphers(opens in a new tab)ssl(opens in a new tab)statement_timeout(opens in a new tab)stats_temp_directory(opens in a new tab)superuser_reserved_connections(opens in a new tab)synchronize_seqscans(opens in a new tab)synchronous_commit(opens in a new tab)synchronous_standby_names(opens in a new tab)syslog_facility(opens in a new tab)syslog_ident(opens in a new tab)syslog_sequence_numbers(opens in a new tab)syslog_split_messages(opens in a new tab)tcp_keepalives_count(opens in a new tab)tcp_keepalives_idle(opens in a new tab)tcp_keepalives_interval(opens in a new tab)temp_buffers(opens in a new tab)temp_file_limit(opens in a new tab)temp_tablespaces(opens in a new tab)timezone_abbreviations(opens in a new tab)trace_notify(opens in a new tab)trace_recovery_messages(opens in a new tab)trace_sort(opens in a new tab)track_activities(opens in a new tab)track_activity_query_size(opens in a new tab)track_commit_timestamp(opens in a new tab)track_counts(opens in a new tab)track_functions(opens in a new tab)track_io_timing(opens in a new tab)transaction_deferrable(opens in a new tab)transaction_isolation(opens in a new tab)transaction_read_only(opens in a new tab)unix_socket_directories(opens in a new tab)unix_socket_group(opens in a new tab)unix_socket_permissions(opens in a new tab)update_process_title(opens in a new tab)vacuum_cost_delay(opens in a new tab)vacuum_cost_limit(opens in a new tab)vacuum_cost_page_dirty(opens in a new tab)vacuum_cost_page_hit(opens in a new tab)vacuum_cost_page_miss(opens in a new tab)vacuum_defer_cleanup_age(opens in a new tab)vacuum_freeze_min_age(opens in a new tab)vacuum_freeze_table_age(opens in a new tab)vacuum_multixact_freeze_min_age(opens in a new tab)vacuum_multixact_freeze_table_age(opens in a new tab)wal_block_size(opens in a new tab)wal_buffers(opens in a new tab)wal_compression(opens in a new tab)wal_consistency_checking(opens in a new tab)wal_keep_segments(opens in a new tab)wal_level(opens in a new tab)wal_log_hints(opens in a new tab)wal_receiver_status_interval(opens in a new tab)wal_receiver_timeout(opens in a new tab)wal_retrieve_retry_interval(opens in a new tab)wal_segment_size(opens in a new tab)wal_sender_timeout(opens in a new tab)wal_sync_method(opens in a new tab)wal_writer_delay(opens in a new tab)wal_writer_flush_after(opens in a new tab)work_mem(opens in a new tab)xmlbinary(opens in a new tab)xmloption(opens in a new tab)zero_damaged_pages(opens in a new tab)