Postgres Pro
Downloads
Home   >   mailing lists

pg_restore takes ages - Mailing list pgsql-general

From Alex
Subject pg_restore takes ages
Date
Msg-id 3F7D22EF.6050507@meerkatsoft.com
Whole thread Raw
Responses Re: pg_restore takes ages  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
List pgsql-general
Tree view 
Hi,
I use pg_restore to load a previously dumped database.  (10mil records).
the load of the data runs quite fast but when starting creating the
triggers for foreign keys it takes forever.

Isnt there are a faster way. after all the triggers in the source db
already made sure the data was clean.

Thanks
Alex

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: return next in recursive function
Next
From: Richard Huxton
Date:
Subject: Re: Type of application that use PostgreSQL