Francisco Reyes wrote: > I had the foreign key in the master table instead of the children. > Deleted RI from master table and put into the inherited partitions. > My whole 230 million rows merged in about an hour!
Heh -- but are the FKs now checked? Try inserting something that violates the constraints and see if they are rejected. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general