| From: | Wes <wespvp(at)syntegra(dot)com> |
|---|---|
| To: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, Jim Nasby <jnasby(at)pervasive(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Adding foreign key constraints without integrity |
| Date: | 2006-06-20 02:23:11 |
| Message-ID: | C0BCC63F.288AC%wespvp@syntegra.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
BTW, I do appreciate any and all suggestions. I hope my last message didn't
come across otherwise. That's not what was intended. It's just that
adding/replacing hardware is not an option right now. Maybe next year...
I'm still trying to dig up another 2GB memory.
The database actually performs extremely well with the current hardware in
the vast majority of cases. I just wish I could cut off the wasted 40+
hours adding the foreign key constraints - it would cut the reload time in
half.
It's too bad the suggestion of creating the FK before hand didn't pan out.
That looked like a good shot.
Wes
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Qingqing Zhou | 2006-06-20 02:36:35 | Re: problem connecting to server |
| Previous Message | Qingqing Zhou | 2006-06-20 02:15:04 | Re: simple query terminated by signal 11 |