| From: | Frits Jalvingh <jal(at)etc(dot)to> |
|---|---|
| To: | Kenneth Marshall <ktm(at)rice(dot)edu> |
| Cc: | "Chellappa, Babu" <Babu_Chellappa(at)unigroup(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Improving PostgreSQL insert performance |
| Date: | 2017-06-09 15:37:10 |
| Message-ID: | CAKhTGFUi7DsN7Y4ECLA5o0CepwkWjPh-pdOhfFbE36h2dL+e9g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
The parameter was
reWriteBatchedInserts = true
Either added in connection properties of in the connection URL like
jdbc:postgresql://localhost:5432/datavault_12_tst?reWriteBatchedInserts=true
BTW: It seems you need a recent driver for this; I'm
using postgresql-42.1.1.jar
On Fri, Jun 9, 2017 at 5:33 PM Kenneth Marshall <ktm(at)rice(dot)edu> wrote:
> On Fri, Jun 09, 2017 at 03:22:35PM +0000, Frits Jalvingh wrote:
> > Hi Babu,
> >
> > That was all already done, as it is common practice for JDBC. Your
> > parameter was added to the code that already did all that - and worked
> > brilliantly there ;)
> >
> Hi Frits,
>
> What was the parameter? I did not see an Email in the thread from Babu.
>
> Regards,
> Ken
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2017-06-09 17:07:07 | Re: Improving PostgreSQL insert performance |
| Previous Message | Kenneth Marshall | 2017-06-09 15:33:33 | Re: Improving PostgreSQL insert performance |