Re: Simple DELETE on modest-size table runs 100% CPU forever

Alvaro Herrera <[email protected]> Thu, 14 Nov 2019 19:22:58 -0300

Newsgroups	gmane.comp.db.postgresql.performance
Message-ID	<[email protected]>

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