PostgreSQL Documentation: wal

Type:	`bool`
Default:	`on`
Context:	`superuser`
Restart:	`false`
Since:	`12`

Recycles WAL files by renaming them

If set to on (the default), this option causes WAL files to be recycled by renaming them, avoiding the need to create new ones. On COW file systems, it may be faster to create new ones, so the option is given to disable this behavior.

Official docs

Search in source code

On StackOverflow

What exactly means the collation 'de-DE-u-kn-true'
De-Identifying PHI For HIPAA
Get breakdown from de-normalized SQL table
Connect to a heroku database with pgadmin
SQL - Conditional Selection and Row De-duplication

On pgsql-hackers

Re: Pre-allocating WAL files
Re: Can postgres ever delete the recycled future WAL files to free-up disk space if max_wal_size is reduced or wal_recycle is set to off?
Re: Race between KeepFileRestoredFromArchive() and restartpoint
Re: Granting SET and ALTER SYSTE privileges for GUCs
Can postgres ever delete the recycled future WAL files to free-up disk space if max_wal_size is reduced or wal_recycle is set to off?

wal_recycle

On StackOverflow

On pgsql-hackers

Comments