Type: | integer |
Défaut: | 65536 (64MB) |
Min: | 64 (64kB) |
Max: | 2147483647 (2147483647kB) |
Unité: | KB |
Contexte: | user |
Redémarrer: | false |
Depuis: | 13 |
Specifies the maximum amount of memory to be used by logical decoding, before some of the decoded changes are written to local disk. This limits the amount of memory used by logical streaming replication connections. It defaults to 64 megabytes (64MB
). Since each replication connection only uses a single buffer of this size, and an installation normally doesn't have many such connections concurrently (as limited by max_wal_senders), it's safe to set this value significantly higher than work_mem, reducing the amount of decoded changes written to disk.
Sur StackOverflow
Sur pgsql-hackers
- Re: Skip collecting decoded changes of already-aborted transactions
- Re: Missing LWLock protection in pgstat_reset_replslot()
- RE: BUG #18641: Logical decoding of two-phase commit fails with TOASTed default values
- Re: Using per-transaction memory contexts for storing decoded tuples
- Make default subscription streaming option as Parallel