On Wed, 19 Jul 2023 at 07:41, Rob Sargent <robjsargent@xxxxxxxxx> wrote: > You might consider deleting portions of the table in separate (consecutive) batches (maybe 5% per delete). And then truncate table is not logged so that might be an alternative. Can you explain why this would be a useful thing to do? It sounds to me like it would just create a load of needless WAL from the deletes and the vacuum that cleans up the dead rows each of which is more likely to cause lag problems on the replica servers, which the OP is trying to avoid. David
