WAL streaming and dropping a large table

2021-10-21 Thread Rory Falloon
Hi, My postgres server setup is thus: a production database, which is using WAL streaming (hot standby) to four other hosts of various latencies. I Have a table that is ~200GB which has been backed up, and now I Want to remove it. The table is not in use, it is a child table to a parent table that

Re: Dealing with latency to replication slave; what to do?

2018-07-24 Thread Rory Falloon
15:39:32 -0400, Rory Falloon wrote: > > Looking for any tips here on how to best maintain a replication slave > which > > is operating under some latency between networks - around 230ms. On a > good > > day/week, replication will keep up for a number of days, but however, &g

Dealing with latency to replication slave; what to do?

2018-07-24 Thread Rory Falloon
Hi, Looking for any tips here on how to best maintain a replication slave which is operating under some latency between networks - around 230ms. On a good day/week, replication will keep up for a number of days, but however, when the link is under higher than average usage, keeping replication act