On Nov 20, 2014, at 6:00 PM, Melvin Davidson wrote:
> Try the following queries. It will give you two .sql files (create_fkeys.sql
> & drop_fkeys.sql).
Thanks!
I tried a variation of that to create DEFERRABLE constraints, and that was a
mess. It appears all the checks ran at the end of the transaction individually
– the process consumed 100% cpu overnight and was stuck on the 'commit' after
16 hours..
So I crossed my fingers and tried your code like this:
BEGIN;
DROP CONSTRAINT ..... x24;
DELETE;
ADD CONSTRAINT ..... x24;
COMMIT;
And that took just over 24 seconds.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
