| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | Mickael van der Beek <mickael(dot)van(dot)der(dot)beek(at)gmail(dot)com> |
| Cc: | Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Array of integer indexed nested-loop semi join |
| Date: | 2022-04-27 14:28:16 |
| Message-ID: | CAMkU=1wa1h_6+5xc19zj=dGxDaMMqOZmJ-XV_ide4xXjPPyN1A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Wed, Apr 27, 2022 at 8:19 AM Mickael van der Beek <
mickael(dot)van(dot)der(dot)beek(at)gmail(dot)com> wrote:
>
> The last query does not finish after waiting for more than 15 minutes.
> (The temporary view creation is very fast and required due to the same
> query in a CTE greatly reducing performance (by more than 5 min.) due to
> the optimisation barrier I'm guessing.)
>
How much over 15 minutes? 20 minutes doesn't seem that long to wait to get
a likely definitive answer. But at the least show us the EXPLAIN without
ANALYZE of it, that should take no milliseconds.
And what does it mean for something to take 5 minutes longer than "never
finishes"?
(Also, putting every or every other token on a separate line does not make
it easier to read)
Cheer,
Jeff
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mickael van der Beek | 2022-04-27 14:54:35 | Re: Array of integer indexed nested-loop semi join |
| Previous Message | Mickael van der Beek | 2022-04-27 12:18:38 | Fwd: Array of integer indexed nested-loop semi join |