Re: [PERFORM] Improving PostgreSQL insert performance - Mailing list pgsql-performance

From Frits Jalvingh
Subject Re: [PERFORM] Improving PostgreSQL insert performance
Date
Msg-id CAKhTGFVBu3Zrsp6oRSpTEgWvnie4Wbx++P6=WTfZOWptLOKj+Q@mail.gmail.com
Whole thread Raw
In response to Re: [PERFORM] Improving PostgreSQL insert performance  ("Sunkara, Amrutha" <amrutha@nytimes.com>)
Responses Re: [PERFORM] Improving PostgreSQL insert performance
List pgsql-performance
I am not doing anything special I guess. I am adding the results of the tests and the programs I'm using to the following page:


The copy example, in Java, is at the end. All of the examples use trivial data and the same data. If you find fault please let me know ;) But the copy does insert the records as they can be seen ;)

On Fri, Jun 9, 2017 at 4:47 PM Sunkara, Amrutha <amrutha@nytimes.com> wrote:
Frits, 

When you use the copy command, are you doing anything special to get the run time that you are indicating?

pgsql-performance by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: [PERFORM] Improving PostgreSQL insert performance
Next
From: Frits Jalvingh
Date:
Subject: Re: [PERFORM] Improving PostgreSQL insert performance