Re: Explain is slow with tables having many columns

Поиск
Список
Период
Сортировка
От legrand legrand
Тема Re: Explain is slow with tables having many columns
Дата
Msg-id 1537818224423-0.post@n3.nabble.com
обсуждение исходный текст
Ответ на Re: Explain is slow with tables having many columns  (Justin Pryzby <pryzby@telsasoft.com>)
Ответы Re: Explain is slow with tables having many columns  (Andres Freund <andres@anarazel.de>)
Список 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


В списке pgsql-performance по дате отправления:

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: Explain is slow with tables having many columns
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Explain is slow with tables having many columns