Re: [9.3 bug] disk space in pg_xlog increases during archive recovery - Mailing list pgsql-hackers

From MauMau
Subject Re: [9.3 bug] disk space in pg_xlog increases during archive recovery
Date
Msg-id 2CBBFA9B035946098E403735F2EBB024@maumau
Whole thread Raw
In response to Re: [9.3 bug] disk space in pg_xlog increases during archive recovery  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: [9.3 bug] disk space in pg_xlog increases during archive recovery
List pgsql-hackers
Hello, Fujii san, all,

From: "Fujii Masao" <masao.fujii@gmail.com>
> On Sun, Jul 28, 2013 at 7:59 AM, MauMau <maumau307@gmail.com> wrote:
> Do you think this should be fixed?
>
> I think so.
>
>> How should it be fixed?
>
> What about removing the restored archived file as soon as it's replayed
> if cascading replication is not enabled (i.e., max_wal_senders = 0 or
> hot_standby = off)? This doesn't seem to break the existing behavior
> in 9.2.

Please find attached the patch to fix the problem.  I changed to keep
restored WAL files in pg_xlog/ only on a cascading standby server.  Could
you review and commit this?

BTW, KeepFileRestoredFromArchive() is also called to keep timeline history
files in pg_xlog/.  What is this for?  Is this necessary for recovery other
than cascading standbys?  This seems to accumulate timeline history files
forever in pg_xlog/.

Regards
MauMau


Attachment

pgsql-hackers by date:

Previous
From: Jeevan Chalke
Date:
Subject: Re: REGEXP_MATCHES() strange behavior with '^' and '$' pattern
Next
From: Fujii Masao
Date:
Subject: Re: Small comment fix in sinvaladt.c