Re: Re: BUG #13685: Archiving while idle every archive_timeout with wal_level hot_standby

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: David Steele <david(at)pgmasters(dot)net>, Robert Haas <robertmhaas(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re: BUG #13685: Archiving while idle every archive_timeout with wal_level hot_standby
Date: 2016-04-20 07:53:35
Message-ID: CAB7nPqRVN4pifvxNv8Cch9jfxOCGOO1HuQhh4iMAO=UuNaS5og@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On Mon, Apr 4, 2016 at 3:22 PM, Michael Paquier
<michael(dot)paquier(at)gmail(dot)com> wrote:
> The approach introducing the concept of WAL progress addresses the
> problem of unnecessary checkpoints and of unnecessary standby
> snapshots. If we take the problem only from the angle of RUNNING_XACTS
> the current logic used to check if a checkpoint should be skipped or
> not is not addressed.

This discussion has been stalling for a while regarding the main
patches... Attached are rebased versions based on the approach with
XLogInsertExtended(). And I have added as well a couple of days ago an
entry on the 9.6 open item page, not as a 9.6 open item, but as an
older bug to keep at least track of this problem.
--
Michael

Attachment Content-Type Size
hs-checkpoints-v10-2.patch text/x-diff 1.7 KB
hs-checkpoints-v10.patch text/x-diff 14.7 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message salianjag 2016-04-20 10:59:47 BUG #14103: stored function encryption
Previous Message Tom Lane 2016-04-20 03:57:00 Re: BUG #14101: Postgres Service Crashes With Memory Error And Does Not Recover

Browse pgsql-hackers by date

  From Date Subject
Next Message Kyotaro HORIGUCHI 2016-04-20 08:18:30 Re: FATAL: could not send end-of-streaming message to primary: no COPY in progress
Previous Message Amit Langote 2016-04-20 07:37:06 Re: Description of ForeignPath