Behavior of debug_parallel_query=regress

From: Rafsun Masud Prince <rafsun(dot)masud(dot)99(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Behavior of debug_parallel_query=regress
Date: 2024-02-26 23:17:06
Message-ID: CA+cc9BUAgXy8A2p-2orxBgwbuoOLBqx8kjckvLbkNgAchgdZjw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

For the context, debug_parallel_query has three states (according to the
documentation):
on: use parallel if safe
off: use parallel if improves performance
regress: use parallel if safe + suppress context line + hide
gather node in explain output

I am looking for a combination of the 'off' and 'regress' state, which is:
use parallel if improves performance + suppress context line (if
parallel is used)

Our project, Apache AGE, has a regression test for cypher MATCH queries. If
that test is run repeatedly, the optimizer chooses a parallel plan at a random
iteration (the issue is reported here:
https://github.com/apache/age/issues/1439)
In that case, the test fails due to the addition of 'CONTEXT: parallel worker'
line in the diff.

I have thought about using 'debug_parallel_query=regress' to suppress the line.
However, the 'regress' state also has the same behavior as 'on', whereas I would
prefer 'off'. I would still want the optimizer to choose a parallel
plan based on
the possibility of performance improvement, rather than forcing it.

Any suggestions on this issue are welcome. It does not have to be related to
debug_parallel_query.

Regards,
Rafsun Masud
Apache AGE Contributor: https://github.com/apache/age

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jason Long 2024-02-27 08:43:32 PostgreSQL Guard
Previous Message Stephen Frost 2024-02-26 19:33:01 Re: Unable to get PostgreSQL 15 with Kerberos (GSS) working