postgres
diff --git a/‎src/backend/utils/sort/tuplestore.c
Copy file name to clipboardExpand all lines: src/backend/utils/sort/tuplestore.c
+10Lines changed: 10 additions & 0 deletions b/‎src/backend/utils/sort/tuplestore.c
Copy file name to clipboardExpand all lines: src/backend/utils/sort/tuplestore.c
+10Lines changed: 10 additions & 0 deletions
@@ -799,6 +799,7 @@ tuplestore_puttuple_common(Tuplestorestate *state, void *tuple)
 	TSReadPointer *readptr;
 	int			i;
 	ResourceOwner oldowner;
+	MemoryContext oldcxt;
 
 	state->tuples++;
 
@@ -850,8 +851,17 @@ tuplestore_puttuple_common(Tuplestorestate *state, void *tuple)
 			oldowner = CurrentResourceOwner;
 			CurrentResourceOwner = state->resowner;
 
+			/*
+			 * We switch out of the state->context as this is a generation
+			 * context, which isn't ideal for allocations relating to the
+			 * BufFile.
+			 */
+			oldcxt = MemoryContextSwitchTo(state->context->parent);
+
 			state->myfile = BufFileCreateTemp(state->interXact);
 
+			MemoryContextSwitchTo(oldcxt);
+
 			CurrentResourceOwner = oldowner;
 
 			/*