Re: faster inserting from dump?

> 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?

Correct... every statement is wrapped in an implicit transaction if an
explicit one is not provided.

> i am guessing that it would be faster
> if i commit after every hundred or thousand?

Correct again.

> is there an easy way to tell psql to do this?

Just use BEGIN; and COMMIT; to denote a transaction block. That's it!

You might also want to research the COPY command for doing bulks imports. I
personally use INSERTs because I need to have my importing error checked,
but if you can guarantee the integrity of the import, COPY is your best bet.

Greg