Wiki / Configuration Parameters
default_toast_compression
This variable sets the default TOAST compression method for values of compressible columns. (This can be overridden for individual columns by setting the COMPRESSION column option in CREATE TABLE or ALTER TABLE.) The supported compression methods are pglz and (if PostgreSQL was compiled with --with-lz4) lz4. The default is pglz.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- boot val
- pglz
- category
- Client Connection Defaults / Statement Behavior
- context
- user
- documented
- true
- enumvals
- pglz, lz4
- extra desc
- Unknown
- lang
- en
- max val
- Unknown
- metadata version
- 18
- min val
- Unknown
- name
- default_toast_compression
- short desc
- Sets the default compression method for compressible values.
- source
- pg-settings-source-snapshot
- unit
- Unknown
- vartype
- enum
Definition PG 18
This variable sets the default TOAST compression method for values of compressible columns. (This can be overridden for individual columns by setting the COMPRESSION column option in CREATE TABLE or ALTER TABLE.) The supported compression methods are pglz and (if PostgreSQL was compiled with --with-lz4) lz4. The default is pglz.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:c407e9668b99b954986f767cc7edc915c784ea35e8d4081a4a8b15c4dbf8c9d7
Text language: en · wiki-repair-20261023:c407e9668b99b954986f767cc7edc915c784ea35e8d4081a4a8b15c4dbf8c9d7