Re: improve EXPLAIN for wide tables

From: Sami Imseih <samimseih(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: improve EXPLAIN for wide tables
Date: 2024-12-30 17:51:06
Message-ID: CAA5RZ0uN+=-7spMnquzV7C4y-YORVZP892Qxhco3TON_kQg7jA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> I wrote:
> > Sami Imseih <samimseih(at)gmail(dot)com> writes:
> >> I am attaching a patch that deals with the RTE_JOIN case.
>
> > I'll take a look. Thanks for the test demonstrating that
> > this makes a visible performance difference.
>
> Pushed with some simplification: we don't need a new flag,
> because none of the callers of set_simple_column_names need it
> to do anything with join RTEs. This is better anyway because
> set_relation_column_names' comment explicitly says it is not
> for join RTEs, and now we don't use it on them ever.
>

Thank you for pushing the enhancement!

Regards,

Sami Imseih
Amazon Web Services (AWS)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2024-12-30 19:35:02 Re: Correct the reference for plpgsql_yyparse()
Previous Message Sami Imseih 2024-12-30 17:43:26 Re: Proposal: Progressive explain