> > I throw last nights backup at it. Data went in in about 1/2 an hour then the > > constraints went in and they took at age. about 2 hours..... > > Is there anyway to speed up the database constraint code? Because quite > > frankly at the current speed your probably better off without the > > constraints.... (Same problem with 7.3 come to think about it.)
I can also attest to the horrendously long time it takes to restore the ADD FOREIGN KEY section... Chris ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html