Xiaolei Li wrote:

> I'm in the process of selecting a DBMS for a project. We've narrowed
> down our choices to MySQL, Oracle, and PostgreSQL. One thing we're not
> sure is the speed of bulk loading.

Well I can address MySQL 5.0.27 and PostgreSQL 8.1.5 bulk loading on a freeBSD
server. PostgreSQL is can be about twice as fast in our testing (YMMV) when
mySQL is using InnoDB tables.

One thing that is either good/bad about mySQL vs pgSQL loading is that pgSQL is
extremely picky about datatypes, and the number of fields must match exactly. So
if you are missing fields or try to cram invalid data using MySQL you might not
get warned. At least I haven't been.

I've used mySQL for years, so don't take this message as FUD/bashing. We run a
large data warehouse on MySQL. It just that things that need a ton of data
integrity and data import verification work much better for *us* on postgresql.

I'm sure someone else has horror stories quite different from our experience.

You may want to post at pgsql-general@postgresql.org for postgresql input on
this topic. No idea about Oracle.

Good luck with your search...
--
Walter