Re: Improving PostgreSQL insert performance
Frits Jalvingh <jal@etc.to>
From: Frits Jalvingh <jal@etc.to>
To: Alvaro Herrera <alvherre@2ndquadrant.com>, "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Date: 2017-06-11T08:44:04Z
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