Re: Best COPY Performance

Поиск
Список
Период
Сортировка
От Craig A. James
Тема Re: Best COPY Performance
Дата
Msg-id 453D443B.20302@modgraph-usa.com
обсуждение исходный текст
Ответ на Re: Best COPY Performance  ("Jim C. Nasby" <jim@nasby.net>)
Ответы Re: Best COPY Performance  ("Jim C. Nasby" <jim@nasby.net>)
Список pgsql-performance
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.

I use Perl extensively, and have never seen a performance problem.  I suspect the perl-to-C "100x improvement" was due
tosome other factor, like a slight change in the schema, indexes, or the fundamental way the client (C vs Perl) handled
thedata during the transformation, or just plain bad Perl code. 

Modern scripting languages like Perl and Python make programmers far, far more productive than the bad old days of
C/C++. Don't shoot yourself in the foot by reverting to low-level languages like C/C++ until you've exhausted all other
possibilities. I only use C/C++ for intricate scientific algorithms. 

In many cases, Perl is *faster* than C/C++ code that I write, because I can't take the time (for example) to write the
high-performancestring manipulation that have been fine-tuned and extensively optimized in Perl. 

Craig


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

Предыдущее
От: "Mara Dalponte"
Дата:
Сообщение: Problems using a function in a where clause
Следующее
От: Péter Kovács
Дата:
Сообщение: Re: Index on two columns not used