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
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)
Hi all,
I have a problem with a delete query I'm not sure how to fix.
I've tried this in 8.1.4 & 8.2.3 and get the same behaviour in both.
This is how I've been able to reproduce it:
create table t1(id serial primary key, email text);
insert into t1(email) select 'email' || n || '@address.c
