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

From Frits Jalvingh
Subject Re: [PERFORM] Improving PostgreSQL insert performance
Date
Msg-id CAKhTGFULKBW0GG48KHt0jsvyPdcJ=i1_bQHvhMaSA0je5f6utQ@mail.gmail.com
Whole thread Raw
In response to Re: [PERFORM] Improving PostgreSQL insert performance  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: [PERFORM] Improving PostgreSQL insert performance
List 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

pgsql-performance by date:

Previous
From: Joe Conway
Date:
Subject: Re: [PERFORM] Improving PostgreSQL insert performance
Next
From: Vladimir Sitnikov
Date:
Subject: Re: [PERFORM] Improving PostgreSQL insert performance