Manage
CO.NF for your Blog
Configuration Snippet Parameter Snippet

default_toast_compression

  1. Documentation
  2. Client Connection Defaults
  3. Statement Behavior
  4. default_toast_compression
COPY SHARING LINK
Type: enum
Default: pglz
Context: user
Restart: false
Values: [pglz, lz4]
Since: 14
Sets the default compression method for compressible values

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.

Official docs

Search in source code

Comments