Postgres Pro
Downloads
Home   >   mailing lists

Partitioning table with billion row - Mailing list pgsql-general

From nuklea
Subject Partitioning table with billion row
Date
Msg-id CAFVF5gOyavQvjYVRdu9AGhJSSLrcH2bZmq2tX1YNuWLnhGuzaA@mail.gmail.com
Whole thread Raw
Responses Re: Partitioning table with billion row  (sachin kotwal <kotsachin@gmail.com>)
List pgsql-general
Tree view
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?

pgsql-general by date:

Previous
From: Torsten Förtsch
Date:
Subject: the new checksum feature
Next
From: Patrick Dung
Date:
Subject: Re: the new checksum feature