Re: Reducing memory usage of insert into select operations? [Solved]

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