[postgis-users] COPY too slow when geometry column is indexed

[strk at refractions.net]

On Fri, Dec 02, 2005 at 09:28:17AM -0000, Mark Cave-Ayland wrote:
> Hi Rick,
> 
> In order to assist with something like this, we need more information such
> as:
> 
> - \dt output of the table you are inserting data into
> - Actual timings for each progressive insert
> - Number of records added during each insert

Also note he was talking about COPY, not insert.
Maybe transaction management does also influence
that, I suggest to perform the tests also with
small transactions.

--strk;