Re: Improving speed of copy
От | Shridhar Daithankar |
---|---|
Тема | Re: Improving speed of copy |
Дата | |
Msg-id | 3D8F036B.9931.3585197@localhost обсуждение исходный текст |
Ответ на | Re: Improving speed of copy ("Nigel J. Andrews" <nandrews@investsystems.co.uk>) |
Список | pgsql-hackers |
On 20 Sep 2002 at 18:41, Nigel J. Andrews wrote: > On Fri, 20 Sep 2002, Shridhar Daithankar wrote: > > > In select test where approx. 15 rows where reported with query on index field, > > mysql took 14 sec. and psotgresql took 17.5 sec. Not bad but other issues > > eclipse the result.. > > I don't know about anyone else but I find this aspect strange. That's 1 second > (approx.) per row retrieved. That is pretty dire for an index scan. The > data/index must be very non unique. Sorry for late reply.. The numbers were scaled off.. Actually my fiend forgot to add units to those number.. The actual numbers are 140ms for mysql and 17 5ms for postgresql.. Further since result are obtained via 'time psql' higher overhead of postgres connection establishement is factored in.. Neck to neck I would say.. ByeShridhar -- Steele's Law: There exist tasks which cannot be done by more than ten men or fewer than one hundred.
В списке pgsql-hackers по дате отправления: