analyze_message_on_hotstandby.patch

application/octet-stream

Filename: analyze_message_on_hotstandby.patch
Type: application/octet-stream
Part: 0
Message: more suitable messages for analyze on hot standby.

Patch

Same data as JSON: GET /api/v1/attachments/:id/patch the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes. API reference →
Format: unified
File+
src/backend/tcop/utility.c 4 1
diff --git a/src/backend/tcop/utility.c b/src/backend/tcop/utility.c
index fde2c82..bd907fe 100644
--- a/src/backend/tcop/utility.c
+++ b/src/backend/tcop/utility.c
@@ -1124,7 +1124,10 @@ standard_ProcessUtility(Node *parsetree,
 
 		case T_VacuumStmt:
 			/* we choose to allow this during "read only" transactions */
-			PreventCommandDuringRecovery("VACUUM");
+			if (((VacuumStmt *) parsetree)->options & VACOPT_VACUUM)
+				PreventCommandDuringRecovery("VACUUM");
+			else
+				PreventCommandDuringRecovery("ANALYZE");
 			vacuum((VacuumStmt *) parsetree, InvalidOid, true, NULL, false,
 				   isTopLevel);
 			break;