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

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