'Debezium: Reduce Load consumption of WalSenderMain activity

I'm currently using Debezium for our postgres databases which are on AWS Aurora (RDS). As you know, debezium makes use of publication (the default name: 'dbz_publication'.

One thing I've noticed is that in AWS, we can see that the WALSenderMain (Write ahead log) activity seems to be constant with a load of AAS (Average Active Sessions) of 1 (100&).

enter image description here

By drilling down further this is caused by the continuous call of querying the publication table.

enter image description here

Note that in the configuration, I've set the 'publication.autocreate.mode' to 'filtered' rather than all the tables.

Is this normal? Would there be any way for me to finetune debezium to lower WALSenderMain activity usuage? Thanks.

postgresqlamazon-auroradebezium


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions