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
