ow <oneway_111(at)yahoo(dot)com> writes:
> --- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Quite honestly, I think they should check their foreign keys.
> Generally speaking, I agree. The problem is that verification of FK
> constraint(s) may take too long, depending on the size of the db and other
> conditions. In my case, on test data, it takes about 1 hour to create tables
> and copy the data, then about 40 min to create indexes, then 4.5 hours to
> create one (1) FK constraint.
If you're seeing this on 7.4, I'd like to see the details of the exact
commands being issued. If it's not 7.4, it's not a relevant
measurement.
regards, tom lane