Re: pg_archivecleanup not deleting anything?

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