Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 9EB4510E9003
	for <pgsql-performance@postgresql.org>;
	Sun,  8 Jan 2012 14:10:17 -0400 (AST)
Received: from 7.mo1.mail-out.ovh.net ([87.98.158.110]
	helo=mo1.mail-out.ovh.net)
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <lists@peufeu.com>) id 1RjxCC-0003QH-4H
	for pgsql-performance@postgresql.org; Sun, 08 Jan 2012 18:10:16 +0000
Received: from mail99.ha.ovh.net (b6.ovh.net [213.186.33.56])
	by mo1.mail-out.ovh.net (Postfix) with SMTP id 454C8FF8160
	for <pgsql-performance@postgresql.org>;
	Sun,  8 Jan 2012 19:11:10 +0100 (CET)
Received: from b0.ovh.net (HELO queueout) (213.186.33.50)
	by b0.ovh.net with SMTP; 8 Jan 2012 20:10:01 +0200
Received: from civ69-1-88-168-96-119.fbx.proxad.net (HELO apollo13)
	(lists%peufeu.com@88.168.96.119)
	by ns0.ovh.net with SMTP; 8 Jan 2012 20:09:59 +0200
Content-Type: text/plain; charset=utf-8; format=flowed; delsp=yes
To: "Marc Eberhard" <eberhardma@googlemail.com>
Cc: pgsql-performance@postgresql.org
X-Ovh-Mailout: 178.32.228.1 (mo1.mail-out.ovh.net)
Subject: Re: Duplicate deletion optimizations
References: <3da8ce0cdf1da4ef873841d01ed0e70a@inaps.org>
	<CAEV0TzCqavqQTtsORx3thrKM3FjhahK4y5Zx4HF4W+-Bosdrmg@mail.gmail.com>
	<CAPaGL57q3h+Z7d=aRSzPrx4Uu0A9w8+eMZ+p=B1FkHKFe22KoA@mail.gmail.com>
	<CAEV0TzDgzktQaqvb+8h_WDibk3V==q+6Syf=vM4J6vtSke7M3g@mail.gmail.com>
	<CAPaGL54Ard6mjBawyR7ExO0LxGUWpYQK-7Rh-TaPq5vTdoESJQ@mail.gmail.com>
	<op.v7pq7pakeorkce@apollo13>
	<CAPaGL55Y-yJxA9LA9TjGAKk8mAVWnpMe6r-bWsBUi4kOdQF3nA@mail.gmail.com>
Date: Sun, 08 Jan 2012 19:09:57 +0100
MIME-Version: 1.0
From: "Pierre C" <lists@peufeu.com>
Message-ID: <op.v7r12vereorkce@apollo13>
In-Reply-To: 
 <CAPaGL55Y-yJxA9LA9TjGAKk8mAVWnpMe6r-bWsBUi4kOdQF3nA@mail.gmail.com>
User-Agent: Opera Mail/11.52 (Linux)
X-Ovh-Tracer-Id: 15849855939311502905
X-Ovh-Remote: 88.168.96.119 (civ69-1-88-168-96-119.fbx.proxad.net)
X-Ovh-Local: 213.186.33.20 (ns0.ovh.net)
X-OVH-SPAMSTATE: OK
X-OVH-SPAMSCORE: -100
X-OVH-SPAMCAUSE: 
 gggruggvucftvghtrhhoucdtuddrfeefkedrfeegucetggdotefuucfrrhhofhhilhgvmecuqfggjfenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujfgurheptgfvufhfffgggffhkfgjfgesthekredttderjeenucfhrhhomhepfdfrihgvrhhrvgcuvedfuceolhhishhtshesphgvuhhfvghurdgtohhmqeenucffohhmrghinhepne
X-Spam-Check: DONE|U 0.5/N
X-VR-SPAMSTATE: OK
X-VR-SPAMSCORE: -100
X-VR-SPAMCAUSE: 
 gggruggvucftvghtrhhoucdtuddrfeefkedrfeegucetggdotefuucfrrhhofhhilhgvmecuqfggjfenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujfgurheptgfvufhfffgggffhkfgjfgesthekredttderjeenucfhrhhomhepfdfrihgvrhhrvgcuvedfuceolhhishhtshesphgvuhhfvghurdgtohhmqeenucffohhmrghinhepne
Content-Transfer-Encoding: quoted-printable
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201201/24
X-Sequence-Number: 46037

> That's almost identical to my tables.

You explained your problem very well ;)

> I certainly will. Many thanks for those great lines of SQL!

You're welcome !
Strangely I didn't receive the mail I posted to the list (received yours =
=20
though).