Re: On disable_cost

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, David Rowley <dgrowleyml(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-08 15:49:53
Message-ID: 1871ece0cc369fddcf89a4e1cbb778db75e2e8c6.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 2024-10-08 at 18:12 +0300, Alena Rybakina wrote:
> > > However you are right that this display will not appear for all
> > > nodes that only contain a data collection procedure, such as Append,
> > > MergeAppend, Gather, etc. And I agree with you that we should
> > > information about it. I also think it’s worth adding additional
> > > information that this option does not appear in the postgres_fdw
> > > extension.
> >
> > I cannot quite follow that either...
>
> I meant this [0].
> [0] https://www.postgresql.org/message-id/CAApHDvpMyKJpLGWRmR3%2B3g4DxrSf6iRpwTRCXMorU0HvgWbocw%40mail.gmail.com
>
> Th disabled description won't display if the MergeAppend and Append
> nodes are used in the query plan. I tried to generalize it, but without
> success. I'm not sure that these nodes can be called accumulating data.
> But I tried to describe this case in the documentation.

You mean you rediscovered the bug that David's patch fixes?

> About postgres_fdw extension disabled nodes won't show [1]. I think we
> should add information about it too.
>
> [1] https://www.postgresql.org/message-id/CA%2BTgmoZRwy8202vxbUPBeZd_Tx5NYVtmpvBnJnOzZS3b81cpkg%40mail.gmail.com

You cannot disable a foreign scan...

Or do you want to see "disabled" if the remote query uses a disabled node?
I think that would be out of scope...

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2024-10-08 16:11:39 overflow bug for inhcounts
Previous Message Alena Rybakina 2024-10-08 15:24:54 Re: Add parallel columns for seq scan and index scan on pg_stat_all_tables and _indexes