Re: improve EXPLAIN for wide tables - Mailing list pgsql-hackers

From Sami Imseih
Subject Re: improve EXPLAIN for wide tables
Date
Msg-id CAA5RZ0uN+=-7spMnquzV7C4y-YORVZP892Qxhco3TON_kQg7jA@mail.gmail.com
Whole thread Raw
In response to Re: improve EXPLAIN for wide tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> I wrote:
> > Sami Imseih <samimseih@gmail.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)



pgsql-hackers by date:

Previous
From: Sami Imseih
Date:
Subject: Re: Proposal: Progressive explain
Next
From: Tom Lane
Date:
Subject: Re: Correct the reference for plpgsql_yyparse()