I am trying this query to delete duplicates from my Database
DELETE FROM table_name
where ctid NOT IN (
GROUP BY ‘column_names’
Having count(*) > 1
Now it was running fine when data was less but as data size and no of rows crossed 10 million this query was going into timeout.
I even made hypertable on the table which i am running this query
please let me know how can i succesfully run this query