pg_dump multi VALUES INSERT

Поиск
Список
Период
Сортировка
От Surafel Temesgen
Тема pg_dump multi VALUES INSERT
Дата
Msg-id CALAY4q9kumSdnRBzvRJvSRf2+BH20YmSvzqOkvwpEmodD-xv6g@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_dump multi VALUES INSERT
Re: pg_dump multi VALUES INSERT
Список pgsql-hackers

Hello,

According to the documentation –inserts option is mainly useful for making dumps that can be loaded into non-PostgreSQL databases and to reduce the amount of rows that might lost during error in reloading but multi values insert command are equally portable and compact and also faster to reload than single row statement. I think it deserve an option of its own

The patch attached add additional option for multi values insert statement with a default values of 100 row per statement so the row lose during error is at most 100 rather than entire table.

Comments?

Regards

Surafel

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Large writable variables
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Large writable variables