Re: JOIN on partitions is very slow

From: daya airody <daya(dot)airody(at)gmail(dot)com>
To: Thomas Kellerer <shammat(at)gmx(dot)net>
Cc: Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: JOIN on partitions is very slow
Date: 2020-03-27 15:24:54
Message-ID: CAFg0VMAu71RxMsZtntPe4sQ4cGAdm=tWsVWK-rLmNiaj4W-v+Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>
>
>
> As none of the columns of the joined table are used, most probably
> this should be re-written as an EXISTS condition.
> Then neither GROUP BY nor DISTINCT is needed.
>
>
I need the columns from joined tables. To keep it simple, I didn't include
them in the query. EXISTS solution won't work for me.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Laurenz Albe 2020-03-28 04:32:57 Re: Best way to delete big amount of records from big table
Previous Message Ekaterina Amez 2020-03-27 15:15:04 Re: Best way to delete big amount of records from big table