Select a documentation version: <button class="button button-with-icon cloud-select-dropdown__button button-primary" aria-haspopup="true">15.13.0</button>

- [Current (18.4.0)](https://docs.cloud.google.com/alloydb/omni/kubernetes/current/docs/reference/database-flags.md.txt)
- [18.4.0](https://docs.cloud.google.com/alloydb/omni/kubernetes/18.4.0/docs/reference/database-flags.md.txt)
- [18.3.0](https://docs.cloud.google.com/alloydb/omni/kubernetes/18.3.0/docs/reference/database-flags.md.txt)
- [18.1.0](https://docs.cloud.google.com/alloydb/omni/kubernetes/18.1.0/docs/reference/database-flags.md.txt)
- [17.10.0](https://docs.cloud.google.com/alloydb/omni/kubernetes/17.10.0/docs/reference/database-flags.md.txt)
- [17.9.0](https://docs.cloud.google.com/alloydb/omni/kubernetes/17.9.0/docs/reference/database-flags.md.txt)
- [17.7.0](https://docs.cloud.google.com/alloydb/omni/kubernetes/17.7.0/docs/reference/database-flags.md.txt)
- [17.5.0](https://docs.cloud.google.com/alloydb/omni/kubernetes/17.5.0/docs/reference/database-flags.md.txt)
- [16.14.0](https://docs.cloud.google.com/alloydb/omni/kubernetes/16.14.0/docs/reference/database-flags.md.txt)
- [16.13.0](https://docs.cloud.google.com/alloydb/omni/kubernetes/16.13.0/docs/reference/database-flags.md.txt)
- [16.11.0](https://docs.cloud.google.com/alloydb/omni/kubernetes/16.11.0/docs/reference/database-flags.md.txt)
- [16.9.0](https://docs.cloud.google.com/alloydb/omni/kubernetes/16.9.0/docs/reference/database-flags.md.txt)
- [16.8.0](https://docs.cloud.google.com/alloydb/omni/kubernetes/16.8.0/docs/reference/database-flags.md.txt)
- [16.3.0](https://docs.cloud.google.com/alloydb/omni/kubernetes/16.3.0/docs/reference/database-flags.md.txt)
- [15.18.0](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.18.0/docs/reference/database-flags.md.txt)
- [15.17.0](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.17.0/docs/reference/database-flags.md.txt)
- [15.15.0](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.15.0/docs/reference/database-flags.md.txt)
- [15.13.0](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/database-flags.md.txt)
- [15.12.0](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.12.0/docs/reference/database-flags.md.txt)
- [15.7.1](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.7.1/docs/reference/database-flags.md.txt)
- [15.7.0](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.7.0/docs/reference/database-flags.md.txt)

<br />

AlloyDB Omni supports all database flags provided by standard [PostgreSQL](https://www.postgresql.org/docs/15/index.html) versions. This page lists the database flags that AlloyDB Omni provides in addition to the standard database flags.

<br />

You use database flags for many operations, including adjusting PostgreSQL
parameters, adjusting options, and configuring and tuning instances.

For more information about setting database flags in
AlloyDB Omni, see [Configure AlloyDB Omni database flags](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/configure-database-flags.md.txt).

## AlloyDB Omni flags

The table's other columns contain additional information
about each AlloyDB Omni flag:

- Click a flag name to see its usage instructions.

- The **Default value** column displays the value that
  AlloyDB Omni sets for this flag in a new instance, unless you specify a different value when creating the instance.

  **Standard default** indicates that the flag has a default value that's not
  set by AlloyDB Omni. To learn more, click the flag's name.
- In the **Restart required** column, **Yes** indicates that
  you need to restart AlloyDB Omni when you set, remove, or
  modify the flag on the instance. The flag's value persists for the
  instance until you modify it again.

- In the **Replica restrictions** column, **Yes** indicates the following
  restrictions on how you can use the flag:

  - Before setting this flag on your cluster's primary instance, set
    the flag on each of your cluster's replica instances.

  - If the primary instance has this flag set, then the value of this
    flag on any replica instance must be equal to or greater
    than the primary instance's value for this flag.

  <br />

[A](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/database-flags.md.txt#postgres-a) \| [C](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/database-flags.md.txt#postgres-c) \| [D](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/database-flags.md.txt#postgres-d) \| [E](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/database-flags.md.txt#postgres-e) \| [F](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/database-flags.md.txt#postgres-f) \| [G](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/database-flags.md.txt#postgres-g) \| [H](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/database-flags.md.txt#postgres-h) \| [I](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/database-flags.md.txt#postgres-i) \| [J](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/database-flags.md.txt#postgres-j) \| [L](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/database-flags.md.txt#postgres-l) \| [M](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/database-flags.md.txt#postgres-m) \| [O](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/database-flags.md.txt#postgres-o) \| [P](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/database-flags.md.txt#postgres-p) \| [R](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/database-flags.md.txt#postgres-r) \| [S](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/database-flags.md.txt#postgres-s) \| [T](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/database-flags.md.txt#postgres-t) \| [V](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/database-flags.md.txt#postgres-v) \| [W](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/database-flags.md.txt#postgres-w)

| AlloyDB Omni flag | Default value | Restart required | Replica restrictions |
|---|---|---|---|
| [alloydb.audit_log_line_prefix](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/alloydb-flags.md.txt#alloydb.audit_log_line_prefix) | `%m [%p]: [%l-1] db=%d,user=%u` | Yes | No |
| [alloydb.enable_pgaudit](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/alloydb-flags.md.txt#alloydb.enable_pgaudit) | `off` | Yes | No |
| [alloydb.log_throttling_window](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/alloydb-flags.md.txt#alloydb.log_throttling_window) | No | No |
| [alloydb.promote_cancel_to_terminate](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/alloydb-flags.md.txt#alloydb.promote_cancel_to_terminate) | `off` | No | No |
| [alloydb.pg_shadow_select_role](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/alloydb-flags.md.txt#alloydb.pg_shadow_select_role) | An empty string | No | No |
| [enable_google_adaptive_autovacuum](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/adaptive-autovacuum.md.txt) | `on` | No | No |
| [google_columnar_engine.auto_columnarization_schedule](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/columnar-engine-flags.md.txt#auto-columnarization-schedule) | `'EVERY 1 HOUR'` | No | No |
| [google_columnar_engine.enable_auto_columnarization](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/columnar-engine-flags.md.txt#enable-auto-columnarization) | `on` | No | No |
| [google_columnar_engine.enable_columnar_scan](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/columnar-engine-flags.md.txt#enable-columnar-scan) | `on` | No | No |
| [google_columnar_engine.enabled](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/columnar-engine-flags.md.txt#enabled) | `off` | Yes | No |
| [google_columnar_engine.memory_size_in_mb](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/columnar-engine-flags.md.txt#memory-size-in-mb) | 30% of instance RAM | Yes | No |
| [google_columnar_engine.omni_storage_cache_directory](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/columnar-engine-flags.md.txt#omni-storage-cache-directory) | An empty string | Yes | No |
| [google_columnar_engine.refresh_threshold_percentage](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/columnar-engine-flags.md.txt#refresh-threshold-percentage) | `50` | No | No |
| [google_columnar_engine.refresh_threshold_scan_count](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/columnar-engine-flags.md.txt#refresh-threshold-scan-count) | `5` | No | No |
| [google_columnar_engine.relations](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/columnar-engine-flags.md.txt#relations) | An empty string | No | No |
| [google_db_advisor.auto_advisor_max_time_in_seconds_per_day](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/index-advisor-flags.md.txt#auto_advisor_max_time_in_seconds_per_day) | `1800` | No | No |
| [google_db_advisor.auto_advisor_schedule](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/index-advisor-flags.md.txt#auto_advisor_schedule) | `'EVERY 24 HOURS'` | No | No |
| [google_db_advisor.enable_auto_advisor](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/index-advisor-flags.md.txt#enable_auto_advisor) | `on` | No | No |
| [google_db_advisor.enabled](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/index-advisor-flags.md.txt#enabled) | `on` | Yes | No |
| [google_db_advisor.max_index_width](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/index-advisor-flags.md.txt#max_index_width) | `2` | No | No |
| [google_db_advisor.max_num_indexable_columns](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/index-advisor-flags.md.txt#max_num_indexable_columns) | `1000` | No | No |
| [google_db_advisor.max_statement_length](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/index-advisor-flags.md.txt#max_statement_length) | `102400` | No | No |
| [google_db_advisor.max_storage_size_in_mb](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/index-advisor-flags.md.txt#max_storage_size_in_mb) | `0` | No | No |
| [google_db_advisor.recommendation_max_time_in_seconds](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/index-advisor-flags.md.txt#recommendation_max_time_in_seconds) | `600` | No | No |
| [google_db_advisor.recommend_indexes_on_partitions](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/index-advisor-flags.md.txt#recommend_indexes_on_partitions) | `off` | No | No |
| [google_db_advisor.top_k_slowest_statements](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/index-advisor-flags.md.txt#top_k_slowest_statements) | `100` | No | No |
| [google_job_scheduler.maintenance_cpu_percentage](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/columnar-engine-flags.md.txt#maintenance-cpu-percentage) | `20` | No | No |
| [google_job_scheduler.max_parallel_workers_per_job](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/columnar-engine-flags.md.txt#max-parallel-workers-per-job) | `2` | No | No |
| [google_ml_integration.enable_model_support](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/model-endpoint-reference) | `off` | No |   |
| [google_storage.log_replay_throttle_read_transactions](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/alloydb-flags.md.txt#google_storage.log_replay_throttle_read_transactions) | `on` | No | No |
| [password.enforce_password_does_not_contain_username](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/password-policy-flags.md.txt#enforce_password_does_not_contain_username) | `OFF` | No | No |
| [password.enforce_expiration](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/password-policy-flags.md.txt#enforce-expiration) | `OFF` | No | No |
| [password.enforce_complexity](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/password-policy-flags.md.txt#enforce-complexity) | `OFF` | No | No |
| [password.expiration_in_days](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/password-policy-flags.md.txt#expiration-in-days) | `90` | No | No |
| [password.min_uppercase_letters](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/password-policy-flags.md.txt#min-uppercase-letters) | `0` | No | No |
| [password.max_uppercase_letters](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/password-policy-flags.md.txt#max-uppercase-letters) | `1000` | No | No |
| [password.min_lowercase_letters](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/password-policy-flags.md.txt#min-lowercase-letters) | `0` | No | No |
| [password.max_lowercase_letters](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/password-policy-flags.md.txt#max-lowercase-letters) | `1000` | No | No |
| [password.min_numerical_chars](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/password-policy-flags.md.txt#min-numerical-chars) | `0` | No | No |
| [password.max_numerical_chars](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/password-policy-flags.md.txt#max-numerical-chars) | `1000` | No | No |
| [password.min_special_chars](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/password-policy-flags.md.txt#min-special-chars) | `0` | No | No |
| [password.max_special_chars](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/password-policy-flags.md.txt#max-special-chars) | `1000` | No | No |
| [password.min_pass_length](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/password-policy-flags.md.txt#min-pass-length) | `0` | No | No |
| [password.max_pass_length](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/password-policy-flags.md.txt#max-pass-length) | `1000` | No | No |
| [password.notify_expiration_in_days](https://docs.cloud.google.com/alloydb/omni/kubernetes/15.13.0/docs/reference/password-policy-flags.md.txt#notify-expiration-in-days) | `30` | No | No |
| [squeeze.worker_autostart](https://github.com/cybertec-postgresql/pg_squeeze#enable--disable-table-processing) | Standard default | No | No |
| [squeeze.worker_role](https://github.com/cybertec-postgresql/pg_squeeze#enable--disable-table-processing) | Standard default | No | No |
| [squeeze.workers_per_database](https://github.com/cybertec-postgresql/pg_squeeze#running-multiple-workers-per-database) | Default value is `1` | No | No |
| [squeeze.max_xlock_time](https://github.com/cybertec-postgresql/pg_squeeze#control-the-impact-on-other-backends) | Default value is `1`. Set to any value between `1` and `2147483647` | No | No |

## Standard PostgreSQL flags that need restart

The following standard PostgreSQL flags require a restart of AlloyDB Omni when you set, remove, or modify the flag on the instance. The flag's value persists for the instance until you modify it again.

- [autovacuum_freeze_max_age](https://www.postgresql.org/docs/15/runtime-config-autovacuum.html#GUC-AUTOVACUUM-FREEZE-MAX-AGE)
- [autovacuum_max_workers](https://www.postgresql.org/docs/15/runtime-config-autovacuum.html#GUC-AUTOVACUUM-MAX-WORKERS)
- [autovacuum_multixact_freeze_max_age](https://www.postgresql.org/docs/15/runtime-config-autovacuum.html#GUC-AUTOVACUUM-MULTIXACT-FREEZE-MAX-AGE)
- [cron.database_name](https://github.com/citusdata/pg_cron#what-is-pg_cron)
- [cron.log_run](https://github.com/citusdata/pg_cron/blob/main/src/pg_cron.c)
- [cron.log_statement](https://github.com/citusdata/pg_cron/blob/main/src/pg_cron.c)
- [cron.max_running_jobs](https://github.com/citusdata/pg_cron/blob/main/src/pg_cron.c)
- [max_connections](https://www.postgresql.org/docs/15/runtime-config-connection.html#GUC-MAX-CONNECTIONS)
- [max_locks_per_transaction](https://www.postgresql.org/docs/15/runtime-config-locks.html#GUC-MAX-LOCKS-PER-TRANSACTION)
- [max_logical_replication_workers](https://www.postgresql.org/docs/15/runtime-config-replication.html#GUC-MAX-LOGICAL-REPLICATION-WORKERS)
- [max_pred_locks_per_page](https://www.postgresql.org/docs/15/runtime-config-locks.html#GUC-MAX-PRED-LOCKS-PER-PAGE)
- [max_pred_locks_per_relation](https://www.postgresql.org/docs/15/runtime-config-locks.html#GUC-MAX-PRED-LOCKS-PER-RELATION)
- [max_pred_locks_per_transaction](https://www.postgresql.org/docs/15/runtime-config-locks.html#GUC-MAX-PRED-LOCKS-PER-TRANSACTION)
- [max_prepared_transactions](https://www.postgresql.org/docs/15/runtime-config-resource.html#GUC-MAX-PREPARED-TRANSACTIONS)
- [max_replication_slots](https://www.postgresql.org/docs/15/runtime-config-replication.html#GUC-MAX-REPLICATION-SLOTS)
- [max_wal_senders](https://www.postgresql.org/docs/15/runtime-config-replication.html#GUC-MAX-WAL-SENDERS)
- [max_worker_processes](https://www.postgresql.org/docs/15/runtime-config-resource.html#GUC-MAX-WORKER-PROCESSES)
- [old_snapshot_threshold](https://www.postgresql.org/docs/15/runtime-config-resource.html#GUC-OLD-SNAPSHOT-THRESHOLD)
- [pg_stat_statements.max](https://www.postgresql.org/docs/15/pgstatstatements.html#id-1.11.7.38.8)
- [pglogical.batch_inserts](https://github.com/2ndQuadrant/pglogical#configuration-options)
- [pglogical.synchronous_commit](https://github.com/2ndQuadrant/pglogical#synchronous-replication)
- [pglogical.use_spi](https://github.com/2ndQuadrant/pglogical#configuration-options)
- [shared_buffers](https://www.postgresql.org/docs/15/runtime-config-resource.html#GUC-SHARED-BUFFERS)
- [track_activity_query_size](https://www.postgresql.org/docs/15/runtime-config-statistics.html#GUC-TRACK-ACTIVITY-QUERY-SIZE)
- [track_commit_timestamp](https://www.postgresql.org/docs/15/runtime-config-replication.html#GUC-TRACK-COMMIT-TIMESTAMP)
- [wal_buffers](https://www.postgresql.org/docs/15/runtime-config-wal.html#GUC-WAL-BUFFERS)