On Apr 4, 2013, at 2:49 PM, Franck Routier wrote:
> Le 04/04/2013 18:25, Tom Lane a écrit :
>> Franck Routier writes:
>>> Right, explain alone takes 3.6 seconds, so the time really seems to go
>>> query planning...
>> Well, you've not shown us the query, so it's all going to be
>> speculation
Are the duplicates evenly distributed? You might have started on a big chunk
of dupes.
I'd go about this by loading my new data in a new table, removing the dupes,
then inserting all the new data into the old table. That way you have more
granular information about the process. And you can do
