Re: When is archive_cleanup called?

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: François Beausoleil <francois(at)seevibes(dot)com>
Cc: Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: When is archive_cleanup called?
Date: 2012-12-09 21:32:03
Message-ID: CAMkU=1z6G+vja2UZQrVtcxjPY+ef+--ybegUVnEL_M_dpM-4qA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Nov 30, 2012 at 6:44 AM, François Beausoleil
<francois(at)seevibes(dot)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 streaming replication 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.

Cheers,

Jeff

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2012-12-09 22:31:32 Re: Query and index ... unexpected result need advice.
Previous Message tim_wilson 2012-12-09 20:05:39 Re: Statistics mismatch between n_live_tup and actual row count