Re: Improving speed of copy - Mailing list pgsql-hackers

From Mark Kirkwood
Subject Re: Improving speed of copy
Date
Msg-id 3D9AA220.7000506@paradise.net.nz
Whole thread Raw
In response to Re: Improving speed of copy  ("Jonah H. Harris" <jharris@nightstarcorporation.com>)
List pgsql-hackers
>Have you tried this with Oracle or similar commercial database?


I have timed COPY/LOAD times for Postgresql/Mysql/Oracle/Db2 -

the rough comparison is :

Db2 and Mysql fastest (Db2 slightly faster)
Oracle approx twice as slow as Db2
Postgresql about 3.5-4 times slower than Db2

However Postgresql can sometimes create indexes faster than Mysql .... 
so that the total time of COPY + CREATE INDEX can be smaller for 
Postgresql than Mysql.

Oracle an Db2 seemed similarish to Postgresql with respect to CREATE INDEX


regards

Mark




pgsql-hackers by date:

Previous
From: Yury Bokhoncovich
Date:
Subject: Re: (Fwd) Re: Any Oracle 9 users? A test please...
Next
From: "Dave Page"
Date:
Subject: Re: psqlODBC *nix Makefile (new 7.3 open item?)