Re: Adding foreign key constraints without integrity

Поиск
Список
Период
Сортировка
Искать
От
Wes
Тема
Re: Adding foreign key constraints without integrity
Дата
Msg-id
C0BCC63F.288AC%wespvp@syntegra.com
Ответ на
Список
Дерево обсуждения
Adding foreign key constraints without integrity check? Wes <wespvp@syntegra.com>
Re: Adding foreign key constraints without integrity Scott Marlowe <smarlowe@g2switchworks.com>
Re: Adding foreign key constraints without integrity Wes <wespvp@syntegra.com>
Re: Adding foreign key constraints without integrity check? "Florian G. Pflug" <fgp@phlo.org>
Re: Adding foreign key constraints without integrity Wes <wespvp@syntegra.com>
Re: Adding foreign key constraints without integrity check? "Florian G. Pflug" <fgp@phlo.org>
Re: Adding foreign key constraints without integrity check? louis gonzales <gonzales@linuxlouis.net>
Re: Adding foreign key constraints without integrity check? "Florian G. Pflug" <fgp@phlo.org>
Re: Adding foreign key constraints without integrity check? louis gonzales <gonzales@linuxlouis.net>
Re: Adding foreign key constraints without integrity check? Bruno Wolff III <bruno@wolff.to>
Re: Adding foreign key constraints without integrity check? louis gonzales <gonzales@linuxlouis.net>
Re: Adding foreign key constraints without integrity check? "Florian G. Pflug" <fgp@phlo.org>
Re: Adding foreign key constraints without integrity Wes <wespvp@syntegra.com>
Re: Adding foreign key constraints without integrity check? "Florian G. Pflug" <fgp@phlo.org>
Re: Adding foreign key constraints without integrity Wes <wespvp@syntegra.com>
Re: Adding foreign key constraints without integrity Jim Nasby <jnasby@pervasive.com>
Re: Adding foreign key constraints without integrity Wes <wespvp@syntegra.com>
Re: Adding foreign key constraints without integrity check? Jan Wieck <JanWieck@Yahoo.com>
Lock changes with 8.1 - what's the right lock? Wes <wespvp@syntegra.com>
Re: Lock changes with 8.1 - what's the right lock? Michael Fuhr <mike@fuhr.org>
Re: Adding foreign key constraints without integrity check? Tom Lane <tgl@sss.pgh.pa.us>
Re: Adding foreign key constraints without integrity Wes <wespvp@syntegra.com>
Re: Adding foreign key constraints without integrity Jim Nasby <jnasby@pervasive.com>
Re: Adding foreign key constraints without integrity Wes <wespvp@syntegra.com>
Re: Adding foreign key constraints without integrity Scott Marlowe <smarlowe@g2switchworks.com>
Re: Adding foreign key constraints without integrity Wes <wespvp@syntegra.com>
Re: Adding foreign key constraints without integrity Wes <wespvp@syntegra.com>
Re: Adding foreign key constraints without integrity Wes <wespvp@syntegra.com>
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


В списке pgsql-general по дате отправления
От: Qingqing Zhou
Дата:
От: Qingqing Zhou
Дата:
FAQ