| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| 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:51:53 |
| Message-ID: | 20180924195153.lje4vmgac5gafqqd@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
Hi,
On 2018-09-24 12:43:44 -0700, legrand legrand wrote:
> 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
Neither of these are related to the problem.
Greetings,
Andres Freund
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nasby, Jim | 2018-09-24 19:53:48 | Re: pgsql: Improve autovacuum logging for aggressive and anti-wraparound ru |
| Previous Message | Andres Freund | 2018-09-24 19:50:48 | Re: Explain is slow with tables having many columns |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vladimir Ryabtsev | 2018-09-24 22:28:15 | Re: Why could different data in a table be processed with different performance? |
| Previous Message | Andres Freund | 2018-09-24 19:50:48 | Re: Explain is slow with tables having many columns |