to
look at whether the FK checking queries need to include explicit casts
...
Well, I reproduced the slowdown with some 20 to 30 different tables.
Anyway, glad I could be of some help, albeit only by testing some
(probably quite meaningless) border cases ... :)
Regards,
Didier
--
Didier Moens
('articles_article_id_key'::text)
...
With two tables each containing some 20.000 entries, the fk creation
time between both of them increases from ~ 1.8 secs to ~ 221 secs.
Regards,
Didier
--
Didier Moens
-
RUG/VIB - Dept. Molecular Biomedical Research - Core IT
tel ++32(9)2645309 fax ++32(9
invested time.
I think the value of tools such as pgAdmin, which provide an almost
bumpless cross-platform migration path, cannot be underestimated.
Regards,
Didier
--
Didier Moens
-
RUG/VIB - Dept. Molecular Biomedical Research - Core IT
http://www.dmb.rug.ac.be