Re: [PERFORM] improving performance for a delete

2008-05-20 Thread PFC
On Tue, 20 May 2008 22:03:30 +0200, kevin kempter <[EMAIL PROTECTED]> wrote: Version 8.3.1 On May 20, 2008, at 1:51 PM, kevin kempter wrote: Hi all; I have 2 tables where I basically want to delete from the first table (seg_id_tmp7) any rows where the entire row already exists in the

Re: [PERFORM] improving performance for a delete

2008-05-20 Thread kevin kempter
Version 8.3.1 On May 20, 2008, at 1:51 PM, kevin kempter wrote: Hi all; I have 2 tables where I basically want to delete from the first table (seg_id_tmp7) any rows where the entire row already exists in the second table (sl_cd_segment_dim) I have a query that looks like this (and it's

[PERFORM] improving performance for a delete

2008-05-20 Thread kevin kempter
Hi all; I have 2 tables where I basically want to delete from the first table (seg_id_tmp7) any rows where the entire row already exists in the second table (sl_cd_segment_dim) I have a query that looks like this (and it's slow): delete from seg_id_tmp7 where customer_srcid::text