pgsql: Avoid archiving XLOG_RUNNING_XACTS on idle server

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Avoid archiving XLOG_RUNNING_XACTS on idle server
Date: 2016-04-04 06:19:04
Message-ID: E1amxqq-0001cw-2x@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Avoid archiving XLOG_RUNNING_XACTS on idle server

If archive_timeout > 0 we should avoid logging XLOG_RUNNING_XACTS if idle.

Bug 13685 reported by Laurence Rowe, investigated in detail by Michael Paquier,
though this is not his proposed fix.
20151016203031(dot)3019(dot)72930(at)wrigleys(dot)postgresql(dot)org

Simple non-invasive patch to allow later backpatch to 9.4 and 9.5

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/bf08f2292ffca14fd133aa0901d1563b6ecd6894

Modified Files
--------------
src/backend/postmaster/bgwriter.c | 5 ++++-
src/backend/storage/ipc/standby.c | 21 +++++++++++++++++++++
2 files changed, 25 insertions(+), 1 deletion(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Andres Freund 2016-04-04 06:24:50 Re: pgsql: Avoid archiving XLOG_RUNNING_XACTS on idle server
Previous Message David Rowley 2016-04-04 02:02:02 Re: pgsql: Copyedit comments and documentation.

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2016-04-04 06:21:59 Re: pgbench more operators & functions
Previous Message Craig Ringer 2016-04-04 06:18:53 Re: Timeline following for logical slots