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 по дате отправления:

Предыдущее
От: jdassen@cistron.nl (J.H.M. Dassen (Ray))
Дата:
Сообщение: Re: compiling on IRIX 6.3 or does anyone hav a tar of the (irix)compiled include dir for me?
Следующее
От: "Gregory Wood"
Дата:
Сообщение: Re: faster inserting from dump?