pg_dump and inserts - Mailing list pgsql-hackers

From Bruce Momjian
Subject pg_dump and inserts
Date
Msg-id 200301272237.h0RMbC616367@candle.pha.pa.us
Whole thread Raw
Responses Re: pg_dump and inserts  (Kevin Brown <kevin@sysexperts.com>)
Re: pg_dump and inserts  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I just checked and pg_dump -d _doesn't_ place the INSERT's in a
transsaction.  Seems it should, and perhaps add a:
SET autocommit TO 'on'

as well.  Of course, that SET would fail when restoring to prior
releases, but they don't have autocommit off anyway so it can be
ignored.  Comments?  This would certainly speed up loads that use
INSERT.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Caught up
Next
From: Curt Sampson
Date:
Subject: Re: Call for objections: put back OIDs in CREATE TABLE