PEERDB_CDC_IDLE_TIMEOUT_SECONDS
defaults to 60s. This is set as an environment variable for the flow worker. OR
max_batch_size
defaults to 100K. This is set as a part an option (WITH part) of the CREATE MIRROR
command.
PEERDB_CDC_IDLE_TIMEOUT_SECONDS
and max_batch_size
PEERDB_CDC_IDLE_TIMEOUT_SECONDS
. You can leave this as default i.e. 60s. Other sane defaults incl. 30s, 40s etc.
max_batch_size
to avoid too many roundtrips and support larger throughputs. You can leave this as default i.e. 100K or go a bit higher say 500K
PEERDB_CDC_IDLE_TIMEOUT_SECONDS
. Can be 5mins, 10mins, 30mins based on what acceptable lag or realtime-ness you are aiming for.
enough max_batch_size
to avoid too many roundtrips and support larger throughputs. You can decide this based on the memory available on the PeerDB instance. For example 100K for instances with low memory (<=16GB) and 1 million for vms with higher RAM (>=32GB RAM)
wal_sender_timeout
to 0
logical_decoding_work_mem