From: | Samir Magar <samirmagar8(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org, Julien Rouhaud <julien(dot)rouhaud(at)dalibo(dot)com> |
Subject: | Fwd: Delay in converting logs from ready state to done state |
Date: | 2016-10-12 07:04:35 |
Message-ID: | CAA=to3jK3BScxcG9vnnP-Q4JVr_O7Eg+tbHR9Y-OXz7C=doxMg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
*Hello Julien,*
*Thank you for your prompt response!*
*we have changed the checkpoint_segment to 170 and use pigz for the pg_xlog
compress.*
*It is working very well now.*
*Thanks again!!*
*Regards,*
*Samir Magar*
On Wed, Oct 12, 2016 at 11:33 AM, Julien Rouhaud <julien(dot)rouhaud(at)dalibo(dot)com>
wrote:
> On 12/10/2016 07:26, Samir Magar wrote:
> > 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'
> >
>
> You could use pigz which is parallel, that could speed up compression.
>
> > checkpoint_segments = 3
> >
>
> this is way to low. If you generate 2000 WAL per hour, you should
> configure it to something like 170 (or 5 min average if 2000 is a
> spike). It'll perform less checkpoint and also generate less WALs.
>
>
> --
> Julien Rouhaud
> http://dalibo.com - http://dalibo.org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Swapnil Vaze | 2016-10-14 12:35:01 | pg_basebackup running slow |
Previous Message | Julien Rouhaud | 2016-10-12 06:03:53 | Re: Delay in converting logs from ready state to done state |