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
