Postgres Pro
Downloads
Home   >   mailing lists

Re: Simple DELETE on modest-size table runs 100% CPU forever - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: Simple DELETE on modest-size table runs 100% CPU forever
Date
Msg-id 20191114222258.GA23194@alvherre.pgsql
Whole thread Raw
In response to Simple DELETE on modest-size table runs 100% CPU forever  (Craig James <cjames@emolecules.com>)
List pgsql-performance
Tree view 
On 2019-Nov-14, 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.

Do you have any FKs there?  If any delete is cascading, and you don't
have an index on the other side, it'd do tons of seqscans.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-performance by date:

Previous
From: Craig James
Date:
Subject: Simple DELETE on modest-size table runs 100% CPU forever
Next
From: Michael Lewis
Date:
Subject: Re: Simple DELETE on modest-size table runs 100% CPU forever