pg_dump and inserts

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема pg_dump and inserts
Дата
Msg-id 200301272237.h0RMbC616367@candle.pha.pa.us
обсуждение исходный текст
Ответы Re: pg_dump and inserts  (Kevin Brown <kevin@sysexperts.com>)
Re: pg_dump and inserts  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Caught up
Следующее
От: Curt Sampson
Дата:
Сообщение: Re: Call for objections: put back OIDs in CREATE TABLE