Re: [PERFORM] Improving PostgreSQL insert performance

Поиск
Список
Период
Сортировка
От Frits Jalvingh
Тема Re: [PERFORM] Improving PostgreSQL insert performance
Дата
Msg-id CAKhTGFUi7DsN7Y4ECLA5o0CepwkWjPh-pdOhfFbE36h2dL+e9g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PERFORM] Improving PostgreSQL insert performance  (Kenneth Marshall <ktm@rice.edu>)
Ответы Re: [PERFORM] Improving PostgreSQL insert performance  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
Список 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@rice.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

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

Предыдущее
От: Kenneth Marshall
Дата:
Сообщение: Re: [PERFORM] Improving PostgreSQL insert performance
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: [PERFORM] Improving PostgreSQL insert performance