Re: Inserting heap tuples in bulk in COPY

Jeff Janes <jeff.janes@gmail.com>

View thread

From: Jeff Janes <jeff.janes@gmail.com>

To: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>

Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2011-11-25T21:32:15Z

Lists: pgsql-hackers

Attachments

bulkwal_copy_1.patch (application/octet-stream) patch

On Fri, Nov 25, 2011 at 12:53 PM, Jeff Janes <jeff.janes@gmail.com> wrote:

> Hi Heikki,
>
> Thanks for this patch.  Doing bulk copies in parallel for me is now
> limited by the IO subsystem rather than the CPU.
>
> This patch, commit number d326d9e8ea1d69, causes fillfactor to be
> ignored for the copy command.  Is this acceptable collateral damage?

Having looked into it a little bit, I think this might be an acceptable fix.

Cheers,

Jeff