Hi Tom, On Thu, Dec 10, 2009 at 6:42 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Glen Barber <glen.j.barber@xxxxxxxxx> writes: >> When schema/data are separated, is the restore treated as INSERTs? > > No, but you'll still get killed on performance by other factors, > particularly incremental index building and retail foreign key checks. > I recommend a close read of > http://www.postgresql.org/docs/8.4/static/populate.html > > What you'll want to do is separate the load into three phases > corresponding to the order that a combined schema+data dump > does it. > Thanks for the pointer. Regards, -- Glen Barber -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
