Re: pg_restore and create FK without verification check

ow <oneway_111@yahoo.com> writes:
> --- Tom Lane <tgl@sss.pgh.pa.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