| From: | Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> |
|---|---|
| To: | shridhar_daithankar(at)persistent(dot)co(dot)in |
| Cc: | pgsql-hackers(at)postgresql(dot)org, jharris(at)nightstarcorporation(dot)com |
| Subject: | Re: Improving speed of copy |
| Date: | 2002-10-02 07:37:04 |
| Message-ID: | 3D9AA220.7000506@paradise.net.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2002-10-02 08:00:06 | Re: [HACKERS] psqlODBC *nix Makefile (new 7.3 open item?) |
| Previous Message | Yury Bokhoncovich | 2002-10-02 07:33:29 | Re: (Fwd) Re: Any Oracle 9 users? A test please... |