[GENERAL] Partitioning table with billion row

[nuklea]

I have a big table referenced by other tables and need to split the table
on several parts.

   1. I create table by CREATE TABLE product_part0 () INHERITS (product);
   2. Move some rows to product_part0 by INSERT INTO product_part0 SELECT *
   FROM ONLY product ORDER BY id LIMIT 200;
   3. Now I need to remove duplicates from master-table. Run DELETE FROM
   ONLY product WHERE id IN (SELECT id FROM product_part0);

With result:

ERROR: update or delete on table "product" violates foreign key constraint
"product_id_refs" on table "searchcache"
DETAIL: Key (id)=(13375) is still referenced from table "searchcache".


So, how to delete duplicate rows?