Search Postgresql Archives

Re: pb with join plan

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: pb with join plan
From: David Rowley <dgrowleyml@xxxxxxxxx>
Date: Wed, 21 Jun 2023 10:54:36 +1200
Cc: "pgsql-general@xxxxxxxxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <CADX_1aaVGTJiU-Fw+vsEF-iTNYxqq9fDtvw9nb_iW9zgP0Bk8Q@mail.gmail.com>
References: <CADX_1aYjA-xZcg+CTq7m++WxjZ7HvHA5=hnhedKNF0TypK6j1Q@mail.gmail.com> <CAApHDvoEuNtDP9=_eRh=bBvZ+dKVBBQbB5x77caHn2Wva1UtPQ@mail.gmail.com> <CADX_1abVROy4x1_drTZNhgm4O9XXu02QPK-8tDktTap11zPcAg@mail.gmail.com> <CAApHDvq0KeGPMkpwytOBYnYuQ+ji4txCyMmnmVExLcRBMLFT2A@mail.gmail.com> <CADX_1aaVGTJiU-Fw+vsEF-iTNYxqq9fDtvw9nb_iW9zgP0Bk8Q@mail.gmail.com>

On Wed, 21 Jun 2023 at 10:26, Marc Millas <marc.millas@xxxxxxxxxx> wrote:
> link to the plan with both clauses ORed (the one not finishing) https://explain.depesz.com/s/jHO2

I'd go with the UNION or UNION ALL idea I mentioned earlier.

David

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- pb with join plan
  - From: Marc Millas
- Re: pb with join plan
  - From: David Rowley
- Re: pb with join plan
  - From: Marc Millas
- Re: pb with join plan
  - From: David Rowley
- Re: pb with join plan
  - From: Marc Millas

Prev by Date: Re: strange behavior of .pgpass file
Next by Date: Re: foreign keys on multiple parent table
Previous by thread: Re: pb with join plan
Next by thread: Re: pb with join plan
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux