| From: | Francisco Reyes <lists(at)stringsutils(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, dev(at)archonet(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Reducing memory usage of insert into select operations? [Solved] |
| Date: | 2008-07-19 23:39:36 |
| Message-ID: | cone.1216510776.37580.10236.1000@zoraida.natserv.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Alvaro Herrera writes:
> Heh -- but are the FKs now checked? Try inserting something that
> violates the constraints and see if they are rejected.
I knew it sounded too good to be true.
1- The trigger was not set in the master (ie nothing went to the children).
2- The master had no index and no RI.. so it was a straight insert.
I corrected (ie set the trigger in the master and RI in the children). Has
been running for 10 hours and has not finished.
The good news is that memory doesn't seem to be going up.
I will give it till tomorrow AM.. and if hasn't finished will turn off the
foreign keys in the children. Already modified the scripts so I can easily
build/drop the foreign keys as needed.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2008-07-20 00:01:28 | Re: Reducing memory usage of insert into select operations? [Solved] |
| Previous Message | Alvaro Herrera | 2008-07-19 21:03:30 | Re: Reducing memory usage of insert into select operations? [Solved] |