pg_dump and inserts
| От | Bruce Momjian |
|---|---|
| Тема | pg_dump and inserts |
| Дата | |
| Msg-id | 200301272237.h0RMbC616367@candle.pha.pa.us обсуждение |
| Ответы |
Re: pg_dump and inserts
Re: pg_dump and inserts |
| Список | 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 по дате отправления: