Quick Links

How import big amounts of data?

From:	Arnau <arnaulist(at)andromeiberica(dot)com>
To:	pgsql-performance(at)postgresql(dot)org
Subject:	How import big amounts of data?
Date:	2005-12-29 09:48:26
Message-ID:	43B3B0EA.6070406@andromeiberica.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-performance

Hi all,

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?

Cheers!

Responses

Re: How import big amounts of data? at 2005-12-29 10:50:49 from Steinar H. Gunderson
Re: How import big amounts of data? at 2005-12-29 11:39:06 from Dennis Bjorklund
Re: How import big amounts of data? at 2005-12-29 14:20:28 from Ron
Re: How import big amounts of data? at 2005-12-29 14:41:05 from Teemu Torma

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Steinar H. Gunderson	2005-12-29 10:50:49	Re: How import big amounts of data?
Previous Message	Ron	2005-12-27 22:47:52	Re: What's the best hardver for PostgreSQL 8.1?