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

From: Steven Lembark <lembark(at)wrkhors(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Cc: lembark(at)wrkhors(dot)com
Subject: Re: performance of loading CSV data with COPY is 50 times faster than Perl::DBI
Date: 2020-02-03 16:02:59
Message-ID: 20200203100259.3a2947f6.lembark@wrkhors.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)wrkhors(dot)com +1 888 359 3508

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Condor 2020-02-03 16:24:21 Re: How to avoid UPDATE on same data in table ?
Previous Message Steven Lembark 2020-02-03 16:01:04 Re: performance of loading CSV data with COPY is 50 times faster than Perl::DBI