Search Postgresql Archives

Re: Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached

Subject: Re: Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached
From: Michael Lewis <mlewis@xxxxxxxxxxx>
Date: Sat, 20 Feb 2021 06:43:28 -0700
Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CAADeyWijZ-P4Gcz30+5+E6tuB17Py6aLAtCPaPypWugaf8Tdyw@mail.gmail.com>
References: <CAADeyWihs2wwUmyUJmEav20sXUanp8P9BpJMQVUApoBQV-HMgg@mail.gmail.com> <CAHOFxGrPSnwrw3yq9XM0k=g84r1bgNc2xyYVxW+NX9FCnSVTTA@mail.gmail.com> <CAADeyWijZ-P4Gcz30+5+E6tuB17Py6aLAtCPaPypWugaf8Tdyw@mail.gmail.com>

Using auto_explain may be needed to catch the plan when it is slow, if the other suggestions don't resolve things for you.

Follow-Ups:
- Re: Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached
  - From: Peter J. Holzer

References:
- Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached
  - From: Alexander Farber
- Re: Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached
  - From: Michael Lewis
- Re: Please help to improve SELECT JOIN performance, EXPLAIN ANALYZE attached
  - From: Alexander Farber