Re: When is archive_cleanup called? - Mailing list pgsql-general

From François Beausoleil
Subject Re: When is archive_cleanup called?
Date
Msg-id 3AE79ECE-599E-49E9-811D-FF0B34053362@seevibes.com
Whole thread Raw
In response to Re: When is archive_cleanup called?  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
Le 2012-12-09 à 16:32, Jeff Janes a écrit :

> On Fri, Nov 30, 2012 at 6:44 AM, François Beausoleil
> <francois@seevibes.com> wrote:
>>
>> How come no new restart points were achieved? I had 4008 WAL archives on my slave. I expected them to be removed as
streamingreplication progressed. Are restart points prevented while long queries are running? 
>
>
> They can be prevented, depending on how you what settings you have for
> max_standby_*_delay.

Ah yes, I have it set to infinity. This is a reporting server.

Thanks for your help!
François

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Problem with aborting entire transactions on error
Next
From: Gražvydas Valeika
Date:
Subject: 9.2.2 RH, Fedora