Re: [GENERAL] delete from ... where not in

2007-02-18 Thread Chris
Tom Lane wrote: Chris <[EMAIL PROTECTED]> writes: I have a problem with a delete query I'm not sure how to fix. Try increasing work_mem --- you want EXPLAIN to show that it's using a hashed subplan. .. and there I was thinking I'd found a bug (bugger!) ;) Thanks for the tip :) -- Postgresq

Re: [GENERAL] delete from ... where not in

2007-02-18 Thread Tom Lane
Chris <[EMAIL PROTECTED]> writes: > I have a problem with a delete query I'm not sure how to fix. Try increasing work_mem --- you want EXPLAIN to show that it's using a hashed subplan. regards, tom lane ---(end of broadcast)