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

2019-11-16 Thread Craig James
Problem solved ... see below. Thanks everyone for your suggestions and insights! On Sat, Nov 16, 2019 at 7:16 AM Jeff Janes wrote: > On Fri, Nov 15, 2019 at 7:27 PM Craig James wrote: > >> On Fri, Nov 15, 2019 at 2:45 PM Jeff Janes wrote: >> BTW, I'll note at this point that "analyze category_

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

2019-11-16 Thread Jeff Janes
On Fri, Nov 15, 2019 at 7:27 PM Craig James wrote: > On Fri, Nov 15, 2019 at 2:45 PM Jeff Janes wrote: > BTW, I'll note at this point that "analyze category_staging_8" prior to > this query made no difference. > Isn't that the wrong table to have analyzed? The offender here is "categories", not