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
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: "Martin A. Marques"
Date:
Subject: Re: [HACKERS] Re: Re: grant privileges to a database [URGENT]
Next
From: eschmid+sic@s.netic.de
Date:
Subject: Re: [HACKERS] Book enters second printing