Re: Improving speed of copy

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Re: Improving speed of copy
Дата
Msg-id 3D9AA220.7000506@paradise.net.nz
обсуждение исходный текст
Ответ на Re: Improving speed of copy  ("Jonah H. Harris" <jharris@nightstarcorporation.com>)
Список 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 по дате отправления:

Предыдущее
От: Yury Bokhoncovich
Дата:
Сообщение: Re: (Fwd) Re: Any Oracle 9 users? A test please...
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: psqlODBC *nix Makefile (new 7.3 open item?)