Re: [HACKERS] Foreign key wierdness

2003-01-23 Thread Didier Moens
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

Re: [HACKERS] Foreign key wierdness

2003-01-23 Thread Didier Moens
- article_id | bigint| not null default nextval('"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 se

Re: [HACKERS] Foreign key wierdness

2003-01-23 Thread Didier Moens
ed 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