Delay in converting logs from ready state to done state

From: Samir Magar <samirmagar8(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Delay in converting logs from ready state to done state
Date: 2016-10-12 05:26:38
Message-ID: CAA=to3jfR91csHz70eXZOTf_9WYzVHKWE2HG4EuZZPRO-XV4Gw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Team,

we are seeing delay in converting logs from ready state to done state in
pg_xlog archive status.

we have seen pg_xlog generated 2000 per hour and it is getting archived
1894. So the speed at which the archiving is done is too slow as compare to
the pg_xlog generation

So our pg_xlog directory keeps filling regularly. What should be the real
cause here?

We cannot see any specific error on pg_log except no space left on device.

current setting:

wal_level = archive

archive_mode = on

max_wal_senders = 3

archive_command = 'gzip < %p > /pgarchive/%f'

checkpoint_segments = 3

checkpoint_timeout = 5min

log_checkpoints = on

archive_timeout = 60

Thanks,

Samir Magar

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Julien Rouhaud 2016-10-12 06:03:53 Re: Delay in converting logs from ready state to done state
Previous Message Pavel Stehule 2016-10-11 11:21:36 Re: Why query plan is different?