Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 65BEA10AC4D3 for ; Sat, 7 Jan 2012 10:18:45 -0400 (AST) Received: from mail.erwied.eu ([85.214.80.157]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RjX6V-0004cW-TG for pgsql-performance@postgresql.org; Sat, 07 Jan 2012 14:18:44 +0000 Received: from dslb-188-109-228-054.pools.arcor-ip.net ([188.109.228.54] helo=erwied.dyndns.org ident=nobody) by mail.erwied.eu with esmtpsa (Exim 4.76#1) id 1RjX5t-0008K4-1E ; Sat, 07 Jan 2012 15:18:01 +0100 Received: from joe-lifebook.dhcp.erwied.de ([172.17.10.70] helo=localhost) by erwied.dyndns.org with esmtpsa (Exim 4.77#2) id 1RjX5r-0002rC-Ry ; Sat, 07 Jan 2012 15:17:59 +0100 Date: Sat, 7 Jan 2012 15:17:58 +0100 From: Jochen Erwied Organization: Creative Chaos Computing X-Priority: 3 (Normal) Message-ID: <1351321158.20120107151758@erwied.eu> To: Misa Simic CC: pgsql-performance@postgresql.org Subject: Re: Duplicate deletion optimizations In-Reply-To: <527717384066155926@unknownmsgid> References: <527717384066155926@unknownmsgid> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201201/19 X-Sequence-Number: 46032 Saturday, January 7, 2012, 3:02:10 PM you wrote: > =E2=80=A2 insert into live from temp where col1, col2 and col3 not exists= in > live 'not exists' is something I'm trying to avoid, even if the optimizer is=20 able to handle it.=20 --=20 Jochen Erwied | home: jochen@erwied.eu +49-208-38800-18, FAX: -19 Sauerbruchstr. 17 | work: joe@mbs-software.de +49-2151-7294-24, FAX: -50 D-45470 Muelheim | mobile: jochen.erwied@vodafone.de +49-173-5404164