Re: BufferAccessStrategy for bulk insert - Mailing list pgsql-hackers

From Robert Haas
Subject Re: BufferAccessStrategy for bulk insert
Date
Msg-id 603c8f070810302005u522eb336p97e4869575ac243f@mail.gmail.com
Whole thread Raw
In response to Re: BufferAccessStrategy for bulk insert  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: BufferAccessStrategy for bulk insert
List pgsql-hackers
> Whatever timings you have are worth publishing.

Here are the timings for copying the first ten million integers into a
one-column table created in the same transaction, with and without the
patch.  As you can see, now that I've corrected my previous error of
not putting CREATE TABLE and COPY in the same transaction, the savings
are quite substantial, about 15%.  Nice!

Trunk:
Time: 18931.516 ms
Time: 18251.732 ms
Time: 17284.274 ms
Time: 15900.131 ms
Time: 16439.617 ms

Patch:
Time: 14852.123 ms
Time: 15673.759 ms
Time: 15776.450 ms
Time: 14160.266 ms
Time: 13374.243 ms

...Robert


pgsql-hackers by date:

Previous
From: "Robert Haas"
Date:
Subject: Re: BufferAccessStrategy for bulk insert
Next
From: "Jaime Casanova"
Date:
Subject: can we create a record of more than one field?