Re: Load data from a csv file without using COPY - Mailing list pgsql-general

From Rob Sargent
Subject Re: Load data from a csv file without using COPY
Date
Msg-id 44b6d6c0-b217-79bd-1bcf-b693817df047@gmail.com
Whole thread Raw
In response to Re: Load data from a csv file without using COPY  (Ravi Krishna <srkrishna@yahoo.com>)
List pgsql-general

On 06/19/2018 03:14 PM, Ravi Krishna wrote:
>> If performance is relevant then your app should probably be using COPY protocol, not line by line inserts. It's
>> supported by most postgresql access libraries. If your app does that then using "\copy" from psql would be
>> an appropriate benchmark.
> Actually the reluctance to not use COPY is to make the benchmark same across two different RDBMS in
> two diff env.
If bulk loading is the actual production target, all your RDBMS choices 
have their own loaders.  I suggest that is what you ought tocompare.


pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: Load data from a csv file without using COPY
Next
From: Paul Jungwirth
Date:
Subject: Re: Is postorder tree traversal possible with recursive CTE's?