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 по дате отправления
От: Tom Lane
Дата:
От: Qingqing Zhou
Дата:
FAQ