From b0c53c2526106f7db12f1b88772071fb351c5d65 Mon Sep 17 00:00:00 2001 From: Tomas Vondra Date: Tue, 30 Sep 2025 02:30:34 +0200 Subject: [PATCH v20251001 18/25] enable compression for tuplestore disabled when random access requested --- src/backend/utils/sort/tuplestore.c | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) diff --git a/src/backend/utils/sort/tuplestore.c b/src/backend/utils/sort/tuplestore.c index c9aecab8d66..db3de5cd6b2 100644 --- a/src/backend/utils/sort/tuplestore.c +++ b/src/backend/utils/sort/tuplestore.c @@ -860,7 +860,13 @@ tuplestore_puttuple_common(Tuplestorestate *state, void *tuple) */ oldcxt = MemoryContextSwitchTo(state->context->parent); - state->myfile = BufFileCreateTemp(state->interXact); + /* + * If requested random access, can't compress the temp file. + */ + if ((state->eflags & EXEC_FLAG_BACKWARD) != 0) + state->myfile = BufFileCreateTemp(state->interXact); + else + state->myfile = BufFileCreateCompressTemp(state->interXact); MemoryContextSwitchTo(oldcxt); -- 2.51.0