Import Database - Mailing list pgsql-general

From Matt
Subject Import Database
Date
Msg-id 954bo4$2d8a$1@news.tht.net
Whole thread Raw
Responses Re: Import Database  ("Brett W. McCoy" <bmccoy@chapelperilous.net>)
List pgsql-general
Hi there,

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

Matt





pgsql-general by date:

Previous
From: Rudolf Potucek
Date:
Subject: Write to postgreSQL via ODBC?
Next
From: eschmid+sic@s.netic.de
Date:
Subject: Re: [HACKERS] Book enters second printing