Re: pg_archivecleanup not deleting anything? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: pg_archivecleanup not deleting anything?
Date
Msg-id 5637A278.2000803@aklaver.com
Whole thread Raw
In response to Re: pg_archivecleanup not deleting anything?  (Paul Jungwirth <pj@illuminatedcomputing.com>)
Responses Re: pg_archivecleanup not deleting anything?
List pgsql-general
On 11/02/2015 09:21 AM, Paul Jungwirth wrote:
> On 11/02/2015 09:11 AM, Adrian Klaver wrote:
>> The *.backup files should not be 16MB and from your original post they
>> looked to be 300 bytes. Now if you have 30K of 16MB files then something
>> else is going on.
>
> Ah, you are right! Sorry for the misunderstanding.

Got to thinking about this. If you see 30K *.backup from February 2014
to now that is(rough calculations) :

postgres@test=# select 30000 / ('2015-11-02'::date -'2014-02-01'::date);
  ?column?
----------
        46



postgres@test=# select (30000 / ('2015-11-02'::date
-'2014-02-01'::date))/ 24.0;
       ?column?
--------------------
  1.9166666666666667


So something is doing a base backup roughly every two hours.

Is that what you would expect?

To put it another way, what is driving the archiving?


>
> Paul
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Paul Jungwirth
Date:
Subject: Re: pg_archivecleanup not deleting anything?
Next
From: Adrian Klaver
Date:
Subject: Re: pg_archivecleanup not deleting anything?