faster inserting from dump? - Mailing list pgsql-general

From chris markiewicz
Subject faster inserting from dump?
Date
Msg-id 01a701c0bdd6$e2374d60$dbb846c6@cmarkiewicz
Whole thread Raw
List 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 by date:

Previous
From: jdassen@cistron.nl (J.H.M. Dassen (Ray))
Date:
Subject: Re: compiling on IRIX 6.3 or does anyone hav a tar of the (irix)compiled include dir for me?
Next
From: "Gregory Wood"
Date:
Subject: Re: faster inserting from dump?