Hi Andreas, Actually there will be sync gap almost 3-4hours during the ETL jobs between primary and streaming replication db ,so I just want to make sure is there any affect in replication bcoz of high value of wal_keep_segments .
Second thing we have implemented pgbackrest in archive_command so archive name will generate in zipped format along with some binary so what will be the restore_command for that if we lose any wals from wal directory of primary db and how it will be applying to replication db via restore_command means is it require password less ssh between primary and replica. Third thing is the high value of wal_keep_segment anyhow affect the checkpoint operation ,dml operation,select query or data write operation from memory to disk? Thanks, Brajendra On Fri, 10 Jul, 2020, 5:44 PM Andreas Kretschmer, <andr...@a-kretschmer.de> wrote: > On 10 July 2020 10:26:25 CEST, Brajendra Pratap Singh < > singh.bpratap...@gmail.com> wrote: > >Hi, > > > >What will happen if the wal_keep_segments value is too high ,is this > > wasted disk space. > > What do you want to achive? > > > Regards, Andreas > > > -- > 2ndQuadrant - The PostgreSQL Support Company >
