Re: Duplicate deletion optimizations

From: Jochen Erwied <jochen(at)pgsql-performance(dot)erwied(dot)eu>
To: Misa Simic <misa(dot)simic(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Duplicate deletion optimizations
Date: 2012-01-07 14:17:58
Message-ID: 1351321158.20120107151758@erwied.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)erwied(dot)eu +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 | work: joe(at)mbs-software(dot)de +49-2151-7294-24, FAX: -50
D-45470 Muelheim | mobile: jochen(dot)erwied(at)vodafone(dot)de +49-173-5404164

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jochen Erwied 2012-01-07 14:18:37 Re: Duplicate deletion optimizations
Previous Message Misa Simic 2012-01-07 14:02:10 Re: Duplicate deletion optimizations