Re: Explain is slow with tables having many columns

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: legrand legrand <legrand_legrand(at)hotmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Explain is slow with tables having many columns
Date: 2018-09-24 19:30:44
Message-ID: 20180924193044.GU2471@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Sarah Conway Schnurr 2018-09-24 19:34:31 Re: Participate in GCI as a Mentor
Previous Message legrand legrand 2018-09-24 19:22:28 Explain is slow with tables having many columns

Browse pgsql-performance by date

  From Date Subject
Next Message legrand legrand 2018-09-24 19:43:44 Re: Explain is slow with tables having many columns
Previous Message legrand legrand 2018-09-24 19:22:28 Explain is slow with tables having many columns