AlloyDB flag |
Default value |
Instance restarts |
Read pool restrictions |
alloydb.enable_auto_explain |
off |
Yes |
No |
alloydb.enable_pg_bigm |
off |
Yes |
No |
alloydb.enable_pg_cron |
off |
Yes |
No |
alloydb.enable_pg_hint_plan |
off |
Yes |
No |
alloydb.enable_pg_wait_sampling |
off |
Yes |
No |
alloydb.enable_pgaudit |
off |
Yes |
No |
alloydb.enable_pglogical |
off |
Yes |
No |
alloydb.iam_authentication |
off |
Yes |
No |
alloydb.logical_decoding |
off |
Yes |
No |
alloydb.log_throttling_window |
No |
No |
alloydb.promote_cancel_to_terminate |
off |
No |
No |
alloydb.pg_shadow_select_role |
An empty string |
No |
No |
auto_explain.log_analyze |
Standard default |
No |
No |
auto_explain.log_buffers |
Standard default |
No |
No |
auto_explain.log_format |
Standard default |
No |
No |
auto_explain.log_level |
Standard default |
No |
No |
auto_explain.log_min_duration |
Standard default |
No |
No |
auto_explain.log_nested_statements |
Standard default |
No |
No |
auto_explain.log_settings |
Standard default |
No |
No |
auto_explain.log_timing |
Standard default |
No |
No |
auto_explain.log_triggers |
Standard default |
No |
No |
auto_explain.log_verbose |
Standard default |
No |
No |
auto_explain.log_wal |
Standard default |
No |
No |
auto_explain.sample_rate |
Standard default |
No |
No |
autovacuum |
Standard default |
No |
No |
autovacuum_analyze_scale_factor |
Standard default |
No |
No |
autovacuum_analyze_threshold |
Standard default |
No |
No |
autovacuum_freeze_max_age |
Standard default |
Yes |
No |
autovacuum_max_workers |
Standard default |
Yes |
No |
autovacuum_multixact_freeze_max_age |
Standard default |
Yes |
No |
autovacuum_naptime |
Standard default |
No |
No |
autovacuum_vacuum_cost_delay |
Standard default |
No |
No |
autovacuum_vacuum_cost_limit |
Standard default |
No |
No |
autovacuum_vacuum_scale_factor |
Standard default |
No |
No |
autovacuum_vacuum_threshold |
Standard default |
No |
No |
autovacuum_work_mem |
Standard default |
No |
No |
checkpoint_completion_target |
Standard default |
No |
No |
checkpoint_timeout |
Standard default |
No |
No |
checkpoint_warning |
Standard default |
No |
No |
commit_delay |
Standard default |
No |
No |
commit_siblings |
Standard default |
No |
No |
constraint_exclusion |
Standard default |
No |
No |
cpu_index_tuple_cost |
Standard default |
No |
No |
cpu_operator_cost |
Standard default |
No |
No |
cpu_tuple_cost |
Standard default |
No |
No |
createrole_self_grant (PostgreSQL 16) |
- |
No |
No |
cron.database_name |
Standard default |
Yes |
No |
cron.log_min_messages |
Standard default |
No |
No |
cron.log_run |
Standard default |
Yes |
No |
cron.log_statement |
Standard default |
Yes |
No |
cron.max_running_jobs |
Standard default |
Yes |
No |
cursor_tuple_fraction |
Standard default |
No |
No |
deadlock_timeout |
Standard default |
No |
No |
debug_io_direct (PostgreSQL 16) |
- |
No |
No |
debug_logical_replication_streaming (PostgreSQL 16) |
buffered |
No |
No |
debug_parallel_query (PostgreSQL 16) |
off |
No |
No |
default_statistics_target |
Standard default |
No |
No |
default_tablespace |
Standard default |
No |
No |
default_transaction_deferrable |
Standard default |
No |
No |
default_transaction_isolation |
Standard default |
No |
No |
effective_cache_size |
80% of instance RAM |
No |
No |
enable_bitmapscan |
Standard default |
No |
No |
enable_google_adaptive_autovacuum |
on |
No |
No |
enable_hashagg |
Standard default |
No |
No |
enable_hashjoin |
Standard default |
No |
No |
enable_indexonlyscan |
Standard default |
No |
No |
enable_indexscan |
Standard default |
No |
No |
enable_material |
Standard default |
No |
No |
enable_mergejoin |
Standard default |
No |
No |
enable_nestloop |
Standard default |
No |
No |
enable_presorted_aggregate (PostgreSQL 16) |
on |
No |
No |
enable_seqscan |
Standard default |
No |
No |
enable_sort |
Standard default |
No |
No |
enable_tidscan |
Standard default |
No |
No |
force_parallel_mode |
Standard default |
No |
No |
from_collapse_limit |
Standard default |
No |
No |
geqo |
Standard default |
No |
No |
geqo_effort |
Standard default |
No |
No |
geqo_generations |
Standard default |
No |
No |
geqo_pool_size |
Standard default |
No |
No |
geqo_seed |
Standard default |
No |
No |
geqo_selection_bias |
Standard default |
No |
No |
geqo_threshold |
Standard default |
No |
No |
gin_fuzzy_search_limit |
Standard default |
No |
No |
gin_pending_list_limit |
Standard default |
No |
No |
google_columnar_engine.auto_columnarization_schedule |
'EVERY 1 HOUR' |
No |
No |
google_columnar_engine.enable_auto_columnarization |
on |
No |
No |
google_columnar_engine.enable_columnar_scan |
on |
No |
No |
google_columnar_engine.enable_vectorized_join |
No |
No |
google_columnar_engine.enabled |
off |
Yes |
No |
google_columnar_engine.memory_size_in_mb |
30% of instance RAM |
Yes |
No |
google_columnar_engine.refresh_threshold_percentage |
50 |
No |
No |
google_columnar_engine.refresh_threshold_scan_count |
5 |
No |
No |
google_columnar_engine.relations |
An empty string |
No |
No |
google_columnar_engine.vectorized_join_threads |
No |
No |
google_db_advisor.auto_advisor_max_time_in_seconds |
1800 |
No |
No |
google_db_advisor.auto_advisor_schedule |
'EVERY 24 HOURS' |
No |
No |
google_db_advisor.enable_auto_advisor |
on |
No |
No |
google_db_advisor.enabled |
on |
Yes |
No |
google_db_advisor.max_index_width |
2 |
No |
No |
google_db_advisor.max_num_indexable_columns |
1000 |
No |
No |
google_db_advisor.max_statement_length |
102400 |
No |
No |
google_db_advisor.max_storage_size_in_mb |
0 |
No |
No |
google_db_advisor.recommendation_max_time_in_seconds |
600 |
No |
No |
google_db_advisor.recommend_indexes_on_partitions |
off |
No |
No |
google_db_advisor.top_k_slowest_statements |
100 |
No |
No |
google_job_scheduler.maintenance_cpu_percentage |
20 |
No |
No |
google_job_scheduler.max_parallel_workers_per_job |
2 |
No |
No |
google_ml_integration.enable_model_support |
off |
No |
|
google_storage.log_replay_throttle_read_transactions |
on |
No |
No |
gss_accept_delegation (PostgreSQL 16) |
off |
No |
No |
hot_standby_feedback |
on |
No |
No |
icu_validation_level (PostgreSQL 16) |
warning |
No |
No |
idle_in_transaction_session_timeout |
Standard default |
No |
No |
idle_session_timeout |
Standard default |
No |
No |
idle_in_transaction_session_timeout (PostgreSQL 16) |
86,400,000 |
No |
No |
join_collapse_limit |
Standard default |
No |
No |
lock_timeout |
Standard default |
No |
No |
log_autovacuum_min_duration |
0 |
No |
No |
log_checkpoints |
Standard default |
No |
No |
log_connections |
Standard default |
No |
No |
log_disconnections |
Standard default |
No |
No |
log_duration |
Standard default |
No |
No |
log_error_verbosity |
Standard default |
No |
No |
log_executor_stats |
Standard default |
No |
No |
log_hostname |
Standard default |
No |
No |
log_line_prefix |
Standard default |
No |
No |
log_lock_waits |
Standard default |
No |
No |
log_min_duration_statement |
Standard default |
No |
No |
log_min_error_statement |
Standard default |
No |
No |
log_min_messages |
Standard default |
No |
No |
log_parser_stats |
Standard default |
No |
No |
log_planner_stats |
Standard default |
No |
No |
log_replication_commands |
Standard default |
No |
No |
log_statement |
Standard default |
No |
No |
log_statement_stats |
Standard default |
No |
No |
log_temp_files |
0 |
No |
No |
maintenance_work_mem |
Standard default |
No |
No |
max_connections |
1000 |
Yes |
Yes |
max_locks_per_transaction |
Standard default |
Yes |
Yes |
max_logical_replication_workers |
Standard default |
Yes |
No |
max_parallel_apply_workers_per_subscription (PostgreSQL 16) |
2 |
No |
No |
max_parallel_maintenance_workers |
Standard default |
No |
No |
max_parallel_workers |
The instance CPU count or 8 , whichever is greater |
No |
No |
max_parallel_workers_per_gather |
Half of the instance CPU count or 2 , whichever is greater |
No |
No |
max_pred_locks_per_page |
Standard default |
Yes |
No |
max_pred_locks_per_relation |
Standard default |
Yes |
No |
max_pred_locks_per_transaction |
Standard default |
Yes |
No |
max_prepared_transactions |
Standard default |
Yes |
Yes |
max_replication_slots |
60 |
Yes |
No |
max_standby_archive_delay |
Standard default |
No |
No |
max_standby_streaming_delay |
Standard default |
No |
No |
max_sync_workers_per_subscription |
Standard default |
No |
No |
max_wal_senders |
50 |
Yes |
Yes |
max_wal_size |
1504 |
No |
No |
max_worker_processes |
64 |
Yes |
Yes |
min_wal_size |
Standard default |
No |
No |
old_snapshot_threshold |
Standard default |
Yes |
No |
parallel_setup_cost |
Standard default |
No |
No |
parallel_tuple_cost |
Standard default |
No |
No |
password_encryption |
Standard default |
No |
No |
password.enforce_password_does_not_contain_username |
OFF |
No |
No |
password.enforce_expiration |
OFF |
No |
No |
password.enforce_complexity |
OFF |
No |
No |
password.expiration_in_days |
90 |
No |
No |
password.min_uppercase_letters |
0 |
No |
No |
password.max_uppercase_letters |
1000 |
No |
No |
password.min_lowercase_letters |
0 |
No |
No |
password.max_lowercase_letters |
1000 |
No |
No |
password.min_numerical_chars |
0 |
No |
No |
password.max_numerical_chars |
1000 |
No |
No |
password.min_special_chars |
0 |
No |
No |
password.max_special_chars |
1000 |
No |
No |
password.min_pass_length |
0 |
No |
No |
password.max_pass_length |
1000 |
No |
No |
password.notify_expiration_in_days |
30 |
No |
No |
pg_bigm.enable_recheck |
Standard default |
No |
No |
pg_bigm.gin_key_limit |
Standard default |
No |
No |
pg_bigm.similarity_limit |
Standard default |
No |
No |
pg_hint_plan.debug_print |
Standard default |
No |
No |
pg_hint_plan.enable_hint |
Standard default |
No |
No |
pg_hint_plan.enable_hint_table |
Standard default |
No |
No |
pg_hint_plan.message_level |
Standard default |
No |
No |
pg_hint_plan.parse_messages |
Standard default |
No |
No |
pg_stat_statements.max |
Standard default |
Yes |
No |
pg_stat_statements.save |
Standard default |
No |
No |
pg_stat_statements.track |
Standard default |
No |
No |
pg_stat_statements.track_utility |
Standard default |
No |
No |
pgaudit.log |
Standard default |
No |
No |
pgaudit.log_catalog |
Standard default |
No |
No |
pgaudit.log_client |
Standard default |
No |
No |
pgaudit.log_level |
Standard default |
No |
No |
pgaudit.log_parameter |
Standard default |
No |
No |
pgaudit.log_relation |
Standard default |
No |
No |
pgaudit.log_statement_once |
Standard default |
No |
No |
pgaudit.role |
Standard default |
No |
No |
pglogical.batch_inserts |
Standard default |
Yes |
No |
pglogical.conflict_log_level |
Standard default |
No |
No |
pglogical.conflict_resolution |
Standard default |
No |
No |
pglogical.extra_connection_options |
Standard default |
No |
No |
pglogical.synchronous_commit |
Standard default |
Yes |
No |
pglogical.use_spi |
Standard default |
Yes |
No |
random_page_cost |
Standard default |
No |
No |
replacement_sort_tuples |
Standard default |
No |
No |
reserved_connections (PostgreSQL 16) |
0 |
Yes |
No |
scram_iterations (PostgreSQL 16) |
4096 |
No |
No |
send_abort_for_crash (PostgreSQL 16) |
off |
No |
No |
send_abort_for_kill (PostgreSQL 16) |
off |
No |
No |
shared_buffers |
80% of instance memory |
Yes |
No |
ssl_max_protocol_version |
Standard default |
No |
No |
ssl_min_protocol_version |
Standard default |
No |
No |
standard_conforming_strings |
Standard default |
No |
No |
statement_timeout |
Standard default |
No |
No |
synchronize_seqscans |
Standard default |
No |
No |
tcp_keepalives_count |
5 |
No |
No |
tcp_keepalives_idle |
300 |
No |
No |
tcp_keepalives_interval |
60 |
No |
No |
temp_buffers |
Standard default |
No |
No |
temp_file_limit |
Standard default |
No |
No |
trace_notify |
Standard default |
No |
No |
trace_recovery_messages |
Standard default |
No |
No |
trace_sort |
Standard default |
No |
No |
track_activities |
Standard default |
No |
No |
track_activity_query_size |
Standard default |
Yes |
No |
track_commit_timestamp |
Standard default |
Yes |
No |
track_counts |
Standard default |
No |
No |
track_functions |
Standard default |
No |
No |
track_io_timing |
on |
No |
No |
vacuum_buffer_usage_limit (PostgreSQL 16) |
256 |
No |
No |
vacuum_cost_delay |
Standard default |
No |
No |
vacuum_cost_limit |
Standard default |
No |
No |
vacuum_freeze_min_age |
Standard default |
No |
No |
vacuum_freeze_table_age |
Standard default |
No |
No |
vacuum_multixact_freeze_min_age |
Standard default |
No |
No |
vacuum_multixact_freeze_table_age |
Standard default |
No |
No |
wal_buffers |
2048 |
Yes |
No |
wal_receiver_timeout |
Standard default |
No |
No |
wal_sender_timeout |
Standard default |
No |
No |
work_mem |
N MB , where N is either 4 or the number of instance vCPUs, whichever is greater |
No |
No |