Re: How import big amounts of data? - Mailing list pgsql-performance

On Thu, 29 Dec 2005, Arnau wrote:

>    Which is the best way to import data to tables? I have to import
> 90000 rows into a column and doing it as inserts takes ages. Would be
> faster with copy? is there any other alternative to insert/copy?

Wrap the inserts inside a BEGIN/COMMIT block and it will be a lot faster.
Copy is even faster, but for just 90000 rows I wouldn't bother.

--
/Dennis Björklund