Thanks for explaining. So I have set:
wal_level = minimal max_wal_senders = 0 and restarted postgresql successfully. The WAL files remain though. Should I delete them manually? As for this: > FWIW I left my few postgres-10 instances at the > defaults, except for one that is actually > replicated, they all seem to be honor the > max_val_size, and the ones that are mostly idle have > only 3-4 16MB files in pg_wal. So I don't know why > yours is using too much space in pg_wal: it could > grow over max_val_size when you run a lot of > transactions, but then it should come down > gradually. Checkpoint, specifically, should trigger > that. I don't know either. I suppose it may be due to the multiple imports and table deletions. But it still looks too much considering that the total .sql file is less than 70MB. -- George _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users