On Sun, 25 Nov 2018 21:16:03 +0200 George via Bacula-users <bacula-users@lists.sourceforge.net> wrote:
> The WAL files remain though. Should I delete them > manually? Postgres will fail to start if they're actually used. I think there are some functions to figure out which ones are used but I suppose you could just move them to e.g. /var/tmp and tehn move them back one by one starting from newest until it starts. > 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. Not really, I know that for e.g. deletions, a WAL stores the entire old row, and the entire new row. You could run a bunch of deletes and inserts and make it grow big, that's how yours could get that way. The issue though is that posgres is largely self-tuning, and normally that would gradually go down to max_wal_size. -- Dmitri Maziuk <dmaz...@bmrb.wisc.edu> _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
