Re: Duplicate deletion optimizations - Mailing list pgsql-performance

From Jochen Erwied
Subject Re: Duplicate deletion optimizations
Date
Msg-id 1351321158.20120107151758@erwied.eu
Whole thread Raw
In response to Re: Duplicate deletion optimizations  (Misa Simic <misa.simic@gmail.com>)
List pgsql-performance
Saturday, January 7, 2012, 3:02:10 PM you wrote:

> • 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
able to handle it.

--
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


pgsql-performance by date:

Previous
From: Misa Simic
Date:
Subject: Re: Duplicate deletion optimizations
Next
From: "Pierre C"
Date:
Subject: Re: Duplicate deletion optimizations