Re: Best COPY Performance

Поиск
Список
Период
Сортировка
От Alex Stapleton
Тема Re: Best COPY Performance
Дата
Msg-id E5CBC793-6CCC-4B47-858A-08C5985E6675@advfn.com
обсуждение исходный текст
Ответ на Re: Best COPY Performance  ("Jim C. Nasby" <jim@nasby.net>)
Список pgsql-performance
On 23 Oct 2006, at 22:59, Jim C. Nasby wrote:
> http://stats.distributed.net used to use a perl script to do some
> transformations before loading data into the database. IIRC, when we
> switched to using C we saw 100x improvement in speed, so I suspect
> that
> if you want performance perl isn't the way to go. I think you can
> compile perl into C, so maybe that would help some.


http://shootout.alioth.debian.org/gp4/benchmark.php?
test=all&lang=perl&lang2=gcc

100x doesn't totally impossible if that is even vaguely accurate and
you happen to be using bits of Perl which are a lot slower than the C
implementation would be...
The slowest things appear to involve calling functions, all the
slowest tests involve lots of function calls.

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Craig A. James"
Дата:
Сообщение: Re: Best COPY Performance
Следующее
От: "Worky Workerson"
Дата:
Сообщение: Re: Best COPY Performance