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 < 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
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 |