Import Benchmark - Mailing list pgsql-general

From Anonymous
Subject Import Benchmark
Date
Msg-id 954bka$2d7a$1@news.tht.net
Whole thread Raw
List pgsql-general
Hi there,

I am trying to find if importing a very large text file is
faster with postgresql or mysql (with mysqlimport).
Each night the transaction system we used dumps
a very large text file which must be loaded into a database,
the speed is very important, mysqlimport takes less than
an hour. Is postgresql likely to be faster or slower at
importing such vast amounts of data?

Matt



pgsql-general by date:

Previous
From: robert gravsjo
Date:
Subject: Re: GUI Interfaces
Next
From: Rudolf Potucek
Date:
Subject: Write to postgreSQL via ODBC?