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