Re: Explain is slow with tables having many columns

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Explain is slow with tables having many columns
Date: 2018-09-24 19:43:44
Message-ID: 1537818224423-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

Justin Pryzby wrote
> On Mon, Sep 24, 2018 at 12:22:28PM -0700, legrand legrand wrote:
>> Hello,
>> I have found that explain on tables with many (hundreds) columns
>> are slow compare to nominal executions.
>
> See also this thread from last month:
>
> https://www.postgresql.org/message-id/flat/CAEe%3DmRnNNL3RDKJDmY%3D_mpcpAb5ugYL9NcchELa6Qgtoz2NjCw%40mail.gmail.com
>
> Justin

maybe, I will check that patch ...

I thought it would also have been related to
https://www.postgresql.org/message-id/CAMkU%3D1xPqHP%3D7YPeChq6n1v_qd4WGf%2BZvtnR-b%2BgyzFqtJqMMQ%40mail.gmail.com

Regards
PAscal

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2018-09-24 19:46:45 Re: Missing const in DSA.
Previous Message Tahir Ramzan 2018-09-24 19:40:06 Re: Participate in GCI as a Mentor

Browse pgsql-performance by date

  From Date Subject
Next Message Andres Freund 2018-09-24 19:50:48 Re: Explain is slow with tables having many columns
Previous Message Justin Pryzby 2018-09-24 19:30:44 Re: Explain is slow with tables having many columns