faster inserting from dump?

Поиск
Список
Период
Сортировка
От chris markiewicz
Тема faster inserting from dump?
Дата
Msg-id 01a701c0bdd6$e2374d60$dbb846c6@cmarkiewicz
обсуждение исходный текст
Список pgsql-general
hello.

how can i increase the speed of building a database from a dump?  there are
currently many tens-of-thousands of insert statements...i assume that a
commit is run after each statement?  i am guessing that it would be faster
if i commit after every hundred or thousand?  is there an easy way to tell
psql to do this?

please respond directly to me if it is not inconvenient.

thanks
chris


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