Re: On disable_cost

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Peter Geoghegan <pg(at)bowt(dot)ie>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: On disable_cost
Date: 2024-10-18 12:09:04
Message-ID: e076b10a1428dc8421d09428490f296fb5b68289.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thanks for the fixes; I have only a few quibbles now.

On Fri, 2024-10-18 at 23:54 +1300, David Rowley wrote:
> --- a/doc/src/sgml/perform.sgml
> +++ b/doc/src/sgml/perform.sgml
> @@ -578,6 +578,33 @@ WHERE t1.unique1 &lt; 100 AND t1.unique2 = t2.unique2;
> discussed <link linkend="using-explain-analyze">below</link>.
> </para>
>
> + <para>
> + When using the enable/disable flags to disable plan node types, many of
> + the flags only discourage the use of the corresponding plan node and don't
> + outright disallow the planner's ability to use the plan node type. This
> + is done so that the planner still maintains the ability to form a plan for
> + a given query. Otherwise, certain queries could be executed when certain

You mean "could *not* be executed".

> + plan node types are disabled. This means it is possible that the planner

The "this" is potentially confusing. Does it refer to queries that cannot be
executed?

> + chooses a plan using a node that has been disabled. When this happens,
> + the <command>EXPLAIN</command> output will indicate this fact.

Here is my attempt on that paragraph:

When using the enable/disable flags to disable plan node types, many of
the flags only discourage the use of the corresponding plan node and don't
outright disallow the planner's ability to use the plan node type.
Otherwise, certain queries could not be executed for lack of an alternative
to using a disabled plan node. As a consequence, it is possible that the
planner chooses a plan using a node that has been disabled. When this
happens, the <command>EXPLAIN</command> output will indicate this fact.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Gustafsson 2024-10-18 12:09:43 Re: Incorrect comment on pg_shadow view
Previous Message Amit Kapila 2024-10-18 11:54:40 Re: Make default subscription streaming option as Parallel