Skip site navigation (1) Skip section navigation (2)

pgsql: Hot Standby feedback for avoidance of cleanup conflicts onstand

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Hot Standby feedback for avoidance of cleanup conflicts onstand
Date: 2011-02-16 19:30:45
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-committerspgsql-hackers
Hot Standby feedback for avoidance of cleanup conflicts on standby.
Standby optionally sends back information about oldestXmin of queries
which is then checked and applied to the WALSender's proc->xmin.
GetOldestXmin() is modified slightly to agree with GetSnapshotData(),
so that all backends on primary include WALSender within their snapshots.
Note this does nothing to change the snapshot xmin on either master or
standby. Feedback piggybacks on the standby reply message.
vacuum_defer_cleanup_age is no longer used on standby, though parameter
still exists on primary, since some use cases still exist.

Simon Riggs, review comments from Fujii Masao, Heikki Linnakangas, Robert Haas



Modified Files
doc/src/sgml/config.sgml                      |   20 +++++++
doc/src/sgml/high-availability.sgml           |   44 +++++++--------
src/backend/access/transam/xlog.c             |   58 +++++++++++++++++++--
src/backend/replication/walreceiver.c         |   36 +++++++++++-
src/backend/replication/walsender.c           |   71 ++++++++++++++++++++++++-
src/backend/storage/ipc/procarray.c           |   45 +++++++++------
src/backend/utils/misc/guc.c                  |    9 +++
src/backend/utils/misc/postgresql.conf.sample |    1 +
src/include/access/xlog.h                     |    1 +
src/include/replication/walprotocol.h         |    9 +++
src/include/replication/walreceiver.h         |    1 +
11 files changed, 245 insertions(+), 50 deletions(-)


pgsql-hackers by date

Next:From: Thom BrownDate: 2011-02-16 19:35:57
Subject: Re: Spontaneous PITR standby activiation
Previous:From: Alvaro HerreraDate: 2011-02-16 19:21:58
Subject: Re: arrays as pl/perl input arguments [PATCH]

pgsql-committers by date

Next:From: Bruce MomjianDate: 2011-02-16 20:17:30
Subject: pgsql: In pg_upgrade, no need to initialize global struct values; they
Previous:From: Tom LaneDate: 2011-02-16 17:40:44
Subject: pgsql: Make a no-op ALTER EXTENSION UPDATE give just a NOTICE,not ERRO

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group