Re: performance of loading CSV data with COPY is 50 times fasterthan Perl::DBI

Поиск
Список
Период
Сортировка
От Steven Lembark
Тема Re: performance of loading CSV data with COPY is 50 times fasterthan Perl::DBI
Дата
Msg-id 20200203100259.3a2947f6.lembark@wrkhors.com
обсуждение исходный текст
Ответ на Re: performance of loading CSV data with COPY is 50 times faster than Perl::DBI  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-general
> 2. postgres has not implicit plan cache, so every INSERT planned
> again and again

Good point: If you are doing something in a loop you probably
want to use prepare_cached() to get the $sth, for both extract
and insert.


-- 
Steven Lembark                                        3646 Flora Place
Workhorse Computing                                St. Louis, MO 63110
lembark@wrkhors.com                                    +1 888 359 3508



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

Предыдущее
От: Steven Lembark
Дата:
Сообщение: Re: performance of loading CSV data with COPY is 50 times fasterthan Perl::DBI
Следующее
От: Condor
Дата:
Сообщение: Re: How to avoid UPDATE on same data in table ?