Can we limit the total size of WAL?

From: FattahRozzaq <ssoorruu(at)gmail(dot)com>
To: pgsql-cluster-hackers(at)postgresql(dot)org
Subject: Can we limit the total size of WAL?
Date: 2015-09-09 06:41:22
Message-ID: CAKnA-A1u2k_8Ovh=QGjtp_hege30qGVsAuctEYMCbpQkTGrVrA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cluster-hackers

Hi all,

I hope this email finds you well. I'm new to PostgreSQL, please
correct me if I'm mislead/incorrect.

I have setup streaming replication using WAL
The archive_command that was generated by Postgres-XL in postgresql.conf was:
archive_command = 'rsync %p
postgres(at)node03:/home/postgres/PGXL/nodes/datanodearchlog/02/%f'

If I run check the total size of the folder in datanode master, it
contains only 14GB:
# du -sh /home/postgres/PGXL/nodes/datanodemaster/03/
14G /home/postgres/PGXL/nodes/datanodemaster/03/

But if I check the total size of the archive folder in datanode slave,
it contains 90GB, each file has 16MB size, with total files 5749:
# du -sh /home/postgres/PGXL/nodes/datanodearchlog/03/
90G /home/postgres/PGXL/nodes/datanodearchlog/03/
# ls -al /home/postgres/PGXL/nodes/datanodearchlog/03/ | grep 16777216 | wc -l
5749

How to limit the amount of files generated by WAL archiving?
Or maybe if we can, how to recycle the files generated by WAL archiving?

Thank you,
FattahRozzaq

Responses

Browse pgsql-cluster-hackers by date

  From Date Subject
Next Message Michael Paquier 2015-09-09 06:52:55 Re: Can we limit the total size of WAL?
Previous Message Rainer Brestan 2015-08-17 10:16:50 [pg_rewind] Request for command line switch to prevent removal of stored procedures