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(at)test=# select 30000 / ('2015-11-02'::date -'2014-02-01'::date);
?column?
----------
46

postgres(at)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(dot)klaver(at)aklaver(dot)com