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@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
