Re: [PERFORM] Foreign key constraints compile faster in 7.4

2005-05-03 Thread Tom Lane
Ashish Arte <[EMAIL PROTECTED]> writes: > We recently upgraded to Postgres 7.4 from 7.3.9 and noticed that the > foreign key constraints compile noticeably faster. In 7.3 the > constraints would typically take more than an hour to run on our > production data. Now they take a minute or two. > Can

[PERFORM] Foreign key constraints compile faster in 7.4

2005-05-03 Thread Ashish Arte
Hello Everybody, We recently upgraded to Postgres 7.4 from 7.3.9 and noticed that the foreign key constraints compile noticeably faster. In 7.3 the constraints would typically take more than an hour to run on our production data. Now they take a minute or two. Can anybody explain such a major per