Re: Improving PostgreSQL insert performance

From: Frits Jalvingh <jal(at)etc(dot)to>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Improving PostgreSQL insert performance
Date: 2017-06-11 08:44:04
Message-ID: CAKhTGFULKBW0GG48KHt0jsvyPdcJ=i1_bQHvhMaSA0je5f6utQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi Alvaro,

I did not try that, to be honest. I am using a single prepared statement so
that the database needs to parse it only once. All executes then use the
batched parameters.
I will try this later on, but I wonder whether having to reparse the
statement every time compared to one prepared statement would actually be
faster.

But thanks for the tip; I will take a look.

Regards,

Frits

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Vladimir Sitnikov 2017-06-11 09:30:29 Re: Improving PostgreSQL insert performance
Previous Message Joe Conway 2017-06-11 04:15:18 Re: Improving PostgreSQL insert performance