Re: Hot Standby: First integrated patch

On Fri, 2008-10-17 at 15:38 +0100, Simon Riggs wrote:
> First integrated patch for Hot Standby, allowing queries to be executed
> while in recovery mode.

Patch with --context=10 to get around apply problems reported by
Merlin.

Thanks.


Some additional info on categorisation of changes to give a better
overview of the change footprint:

Major changes for Hot Standby
backend/access/transam/xact.c       |  679 ++++++++++++++++++!!!!!!!!!
backend/storage/ipc/procarray.c     |  787 +++++++++++++++++++++++++!!!
backend/storage/lmgr/proc.c         |  107 ++++
backend/postmaster/postmaster.c     |   75 ++
backend/utils/time/tqual.c          |   29 !

Minor changes for Hot Standby
backend/utils/init/postinit.c       |    8
backend/access/transam/multixact.c  |   14
backend/access/transam/slru.c       |   16
backend/access/transam/twophase.c   |    2

Required changes for bgwriter in recovery mode
backend/access/transam/xlog.c       |  670 +++++++++++++++++--!!!!!!!!!!
backend/postmaster/bgwriter.c       |  206 ++++++++-

Minor utility changes
bin/pg_controldata/pg_controldata.c |    3
bin/pg_resetxlog/pg_resetxlog.c     |    2

Changed header files for above
include/access/xact.h               |   27 +
include/access/xlog.h               |   54 +!
include/access/xlog_internal.h      |    6
include/catalog/pg_control.h        |    6
include/postmaster/bgwriter.h       |    6
include/storage/pmsignal.h          |    1
include/storage/proc.h              |    4
include/storage/procarray.h         |   17
include/utils/snapshot.h            |   67 ++!

Prevent operations that would fail in recovery mode
backend/access/heap/pruneheap.c     |    8
backend/commands/discard.c          |    1
backend/commands/lockcmds.c         |   12
backend/commands/sequence.c         |    2
backend/storage/lmgr/lock.c         |    9
backend/tcop/utility.c              |   21
backend/utils/adt/txid.c            |    6
include/miscadmin.h                 |    3

Additional/Changed Comments only
backend/access/transam/clog.c       |    3
backend/access/transam/subtrans.c   |    3
backend/storage/buffer/README       |    9

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support