Hello,
This is more of a question than actual issue of the plugin.
Is there a way to use ability of pgBackRest to create replica via multiple threads? It seems that cnpg uses pg_basebackup for this purpose which is quite slow by design (as process is single threaded). On Virtual Machines with big databases I would use ability of pgBackRest to properly create replica:
- utilize latest backup via multiple threads
- bring all necessary WALs from archive and primary again via multiple threads
- create replication slot and finally sync DBs
Above steps save a lot of time due to parallelism, especially for big DB's.
Perhaps, question lies in CNPG-I API. If so, should we raise this request with cnpg as well?
Best regards,
Boris
Hello,
This is more of a question than actual issue of the plugin.
Is there a way to use ability of pgBackRest to create replica via multiple threads? It seems that
cnpgusespg_basebackupfor this purpose which is quite slow by design (as process is single threaded). On Virtual Machines with big databases I would use ability of pgBackRest to properly create replica:Above steps save a lot of time due to parallelism, especially for big DB's.
Perhaps, question lies in CNPG-I API. If so, should we raise this request with
cnpgas well?Best regards,
Boris