Adding foreign key constraints without integrity check?
От
Wes
Тема
Adding foreign key constraints without integrity check?
Дата
Msg-id
C0BB8700.2875D%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>
Is there a way to add a foreign key constraint without having to wait for it to check the consistency of all existing records? If a database is being reloaded (pg_dumpall then load), it really shouldn't be necessary to check the referential integrity - or at least I should be able to stipulate that I am accepting that risk. My database reload is currently taking about 6 hours to load the data, 42 hours to reindex, and about another 40 hours or so to check the foreign key constraints (about 1.2 billion rows). That's a very long time to be out of commission. I'd really like to eliminate that second 40 hours so I can get it down to a normal weekend. Wes
В списке pgsql-general по дате отправления