From b95a720a487b5027af1b9e4a12542800598ff5de Mon Sep 17 00:00:00 2001 From: Simon Riggs Date: Sat, 13 Feb 2010 01:32:20 +0000 Subject: Re-enable max_standby_delay = -1 using deadlock detection on startup process. If startup waits on a buffer pin we send a request to all backends to cancel themselves if they are holding the buffer pin required and they are also waiting on a lock. If not, startup waits until max_standby_delay before cancelling any backend waiting for the requested buffer pin. --- src/include/storage/procsignal.h | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'src/include/storage/procsignal.h') diff --git a/src/include/storage/procsignal.h b/src/include/storage/procsignal.h index 2a67a62a92..0b5316e691 100644 --- a/src/include/storage/procsignal.h +++ b/src/include/storage/procsignal.h @@ -7,7 +7,7 @@ * Portions Copyright (c) 1996-2010, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $PostgreSQL: pgsql/src/include/storage/procsignal.h,v 1.4 2010/01/23 16:37:12 sriggs Exp $ + * $PostgreSQL: pgsql/src/include/storage/procsignal.h,v 1.5 2010/02/13 01:32:20 sriggs Exp $ * *------------------------------------------------------------------------- */ @@ -38,6 +38,7 @@ typedef enum PROCSIG_RECOVERY_CONFLICT_LOCK, PROCSIG_RECOVERY_CONFLICT_SNAPSHOT, PROCSIG_RECOVERY_CONFLICT_BUFFERPIN, + PROCSIG_RECOVERY_CONFLICT_STARTUP_DEADLOCK, NUM_PROCSIGNALS /* Must be last! */ } ProcSignalReason; -- cgit v1.2.1