On Fri, Nov 15, 2019 at 2:45 PM Jeff Janes wrote:
> On Thu, Nov 14, 2019 at 5:20 PM Craig James wrote:
>
>> I'm completely baffled by this problem: I'm doing a delete that joins
>> three modest-sized tables, and it gets completely stuck: 100% CPU use
>> forever. Here's the query:
>>
>>
>> Aggre
On Thu, Nov 14, 2019 at 5:20 PM Craig James wrote:
> I'm completely baffled by this problem: I'm doing a delete that joins
> three modest-sized tables, and it gets completely stuck: 100% CPU use
> forever. Here's the query:
>
>
> Aggregate (cost=193.54..193.55 rows=1 width=8)
> -> Nested Loo
Hey James,
Looking at your select query, if that’s taking forever STILL. Could it be
because of the IN clause? If so, try using EXISTS instead of IN.. should give
much better results.
From: Craig James
Sent: Friday, November 15, 2019 1:07 PM
To: Andres Freund
Cc: pgsql-performance@lists.postg
On Thu, Nov 14, 2019 at 2:29 PM Andres Freund wrote:
> Hi,
>
> On 2019-11-14 14:19:51 -0800, Craig James wrote:
> > I'm completely baffled by this problem: I'm doing a delete that joins
> three
> > modest-sized tables, and it gets completely stuck: 100% CPU use forever.
> > Here's the query:
>
>
