# Configuration Parameters

> Added, modified, removed, and default-value changes for configuration parameters.

---

LLMS index: [llms.txt](/en/llms.txt)

---

<div class="feature-source-note"><span class="feature-edition-badge">Beta 1</span><span><strong>Source pages:</strong> PDF 89-93</span><span><a href="https://github.com/nori-shinoda/documents/blob/1773200c5362476c4a549222b7d17fa91f546cae/postgresql19_beta1_new_features_en_20260606-1.pdf">Original PDF on GitHub</a></span></div>

<p class="feature-page-marker" id="pgfeat-19-configuration-pdf-page-89">PDF page 89</p>

In PostgreSQL 19, the following parameters have been changed.

#### 3.3.1 Added Parameters {#pg19-3-3-1-added-parameters}

The following parameters have been added. The file_extend_method parameter will be backported to PostgreSQL 16 and later. [[06473f5](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=06473f5a344df8c9594ead90a609b86f6724cff8), [8e11859](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=8e11859102f947e6145acdd809e5cdcdfbe90fa5), [dd3ae37](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=dd3ae378301f7e84c18f7a90f183c3cd4165c0da), [67c2097](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=67c20979ce72b8c236622e5603f9775968ff501c), [f94e914](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=f94e9141a0bbb365f8194517e142746466ee7014), [1d92e0c](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=1d92e0c2cc4789255c630d8776bbe85ca9ebc27f), [4f43302](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=4f433025f666fa4a6209f0e847715767fb1c7ace), [d7965d6](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=d7965d65fc5bb2139bc51c051c11428414c65160), [a8f45de](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=a8f45dee91768cf1447ffaf2527e499e75a194c3), [1ff3180](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=1ff3180ca0169556984ab83759477f593129794d), [e76d8c7](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=e76d8c749c3152657711ed733f0aea61c0e36a91), [d1c01b7](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=d1c01b79d4ae90e52bf9db9c05c9de17b7313e85)]

**Table 30.** Added Parameters

| Parameter name | Description (Context) | Default value |
| --- | --- | --- |
| autovacuum_analyze_score_weight | Specifies the scaling factor of the analyze threshold (sighup) | 1.0 |
| autovacuum_freeze_score_weight | Specifies the scaling factor of the transaction ID age (sighup) | 1.0 |
| autovacuum_max_parallel_workers | Sets the maximum number of autovacuum parallel workers (sighup) | 0 |
| autovacuum_multixact_freeze_score_weight | Specifies the scaling factor of the multixact ID age (sighup) | 1.0 |
| autovacuum_vacuum_insert_score_weight | Specifies the scaling factor of the vacuum insert threshold (sighup) | 1.0 |
| autovacuum_vacuum_score_weight | Specifies the scaling factor of the vacuum threshold (sighup) | 1.0 |
| autovacuum_worker_slots | Specifies the number of backend slots to reserve for autovacuum worker (postmaster) | 16 |
| debug_exec_backend | Reports whether PostgreSQL has been built with EXEC_BACKEND enabled (internal) | off |
| debug_print_raw_parse | Output the parse tree without converting it (user) | off |
| effective_wal_level | Effective WAL output level (internal) | replica |
| enable_eager_aggregate | Enable eager aggregation execution plan (user) | on |
| file_extend_method | File extension methods (sighup) | posix_fallocate |
| hosts_file | SSL/SNI filename (postmaster) | {PGDATA}/pg_hosts.conf |
| io_max_workers | Maximum number of I/O workers (sighup) | 8 |
| io_min_workers | Minimum number of I/O workers (sighup) | 2 |
| io_worker_idle_timeout | Maximum idle time for I/O workers (sighup) | 60000 |
| io_worker_launch_interval | Minimum interval between starting new I/O workers (sighup) | 100ms |
| log_autoanalyze_min_duration | Log output time for automatic ANALYZE execution (sighup) | 10min |
| max_repack_replication_slots | Number of replication slots reserved for executing REPACK (postmaster) | 5 |
| min_eager_agg_group_size | Minimum memory allocation when using eager aggregation (user) | 8 |
| password_expiration_warning_threshold | Period for outputting password expiration warnings (sighup) | 7d |
| ssl_sni | Whether to use SNI for SSL connections (sighup) | off |
| timing_clock_source | Specify the clock source used for timing measurements (superuser) | auto (tsc) |
| wal_sender_shutdown_timeout | Timeout for stopping the WAL sender process (user) | -1 |

<p class="feature-page-marker" id="pgfeat-19-configuration-pdf-page-90">PDF page 90</p>

##### Password Expiration Warning {#pg19-p90-password-expiration-warning}

If the password's expiration date is within the range specified by the password_expiration_warning_threshold parameter (default value: 7 days), a warning will be output during authentication. [[1d92e0c](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=1d92e0c2cc4789255c630d8776bbe85ca9ebc27f)]

<p class="feature-page-marker" id="pgfeat-19-configuration-pdf-page-91">PDF page 91</p>

**Example 107.** Password Expiration Warning

```text
$ psql -h dbsvr1 -d postgres -U user1
Password for user user1: <<Password>>
WARNING:  role password will expire soon
DETAIL:  The password for role "user1" will expire in 13 hours.
psql (19beta1)
Type "help" for help.
postgres=>
```

#### 3.3.2 Changed Parameters {#pg19-3-3-2-changed-parameters}

The following parameters have been changed in terms of setting range and choices. [[38e0190](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=38e0190ced714b33c43c9676d768cc6814fc662a), [1efdd7c](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=1efdd7cc630a963e56f34d44877d2097b98166d6), [8a6af3a](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=8a6af3ad08799755e575275d0df5feb7b102ca35), [12da457](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=12da45742cfd15d9fab151b25400d96a1febcbde), [bf5da5d](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=bf5da5d6cae959d8119b4b137ddd9912292b8014)]

**Table 31.** Changed Parameters

| Parameter name | Change |
| --- | --- |
| data_checksums | f the checksum is currently being enabled, the status changes to "inprogress-on". Data type changed from boolean to enum |
| extension_control_path | If an extension with the same name exists in the specified path, the first path found is output to the pg_available_extensions view |
| io_workers | Split into io_max_workers and io_min_workers |
| log_min_messages | The log output level can now be changed for each process type. |
| sync_replication_slots | To enable this parameter, the wal_level parameter must be set to logical |
| wal_receiver_timeout | The context for configuration changes has been changed from signup to user |

##### Specifying the log_min_messages parameter {#pg19-p91-specifying-the-log-min-messages-parameter}

The log_min_messages parameter now supports changing the log output level on a per-process basis. Specify process names and levels separated by colons (:), and separate multiple processes with commas (,). [[38e0190](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=38e0190ced714b33c43c9676d768cc6814fc662a)]

<p class="feature-page-marker" id="pgfeat-19-configuration-pdf-page-92">PDF page 92</p>

**Table 32.** String for specifying the process

| Process name setting | Description |
| --- | --- |
| archiver | WAL archiver process |
| autovacuum | Autovacuum Launcher, Autovacuum Worker process |
| backend | Backend process |
| bgworker | Background worker process |
| bgwriter | Background writer process |
| checkpointer | Checkpointer process |
| ioworker | I/O Worker process |
| postmaster | Postmaster process |
| slotsyncworker | Replication Slot Synchronous Worker process |
| startup | Startup process |
| syslogger | Logger process |
| walreceiver | WAL Receiver process |
| walsender | WAL Senfer process |
| walsummarizer | WAL Summarizer process |
| walwriter | WAL Writer process |

**Example 108.** Changing the log\_min\_messages parameter

```text
postgres=# SET log_min_messages TO 'warning, autovacuum:debug1' ;
SET
```

#### 3.3.3 Changed Default Values {#pg19-3-3-3-changed-default-values}

The following parameters have changed default values. [[2aac62b](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=2aac62be8cbb870ccf8c5b3fbb8a4e4aa8a14a73), [7f8c88c](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=7f8c88c2b872cb74882ab93dcb05529dab2a10bc), [79534f9](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=79534f90657c37c5238e5341a111dedd26d9c0fb)]

**Table 33.** Parameters whose default values have been changed

| Parameter name | PostgreSQL 18 | PostgreSQL 19 | Note |
| --- | --- | --- | --- |
| jit | on | Off |  |
| log_lock_waits | off | On |  |
| max_locks_per_transactionserver_version | 64 | 128 |  |
|  | 18.4 | 19beta1 |  |
| server_version_num | 180004 | 190000 |  |

<p class="feature-page-marker" id="pgfeat-19-configuration-pdf-page-93">PDF page 93</p>

In binaries built using the "configure" command with the --with-lz4 option, the default value for the default_toast_compression parameter is lz4.

#### 3.3.4 Removed Parameters {#pg19-3-3-4-removed-parameters}

The following parameters have been removed. [[4576208](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=45762084545ec14dbbe66ace1d69d7e89f8978ac)]

**Table 34.** Removed Parameters

| Parameter name | Reason |
| --- | --- |
| escape_string_warning | Due to the standard_conforming_strings parameter being fixed, this is no longer necessary. |