Thanks....
CTAS (Create Table As Select) command works fine!!! With great performance.
I think it is the best way to correct the data...(apparently)
I didnt know about "select DISTINCT". I am going to read about it.
Thank you.
Quoting Bricklen Anderson <[EMAIL PROTECTED]>:
Is there a way to delete those duplicated records faster??? Remembering the
table have aprox 360.000 records...
Is better I create other table and copy those data??? How should I
created???
for 180k rows (which isn't many) just do a CTAS (Create Table As Select):
create table lanctos_distinct as select distinct * from lanctos;
truncate table lanctos;
alter table lanctos_distinct rename to lanctos;
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
