| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Inserting heap tuples in bulk in COPY |
| Date: | 2011-11-25 21:32:15 |
| Message-ID: | CAMkU=1w_EeLZ3Fqy1vJotikLZsPO3_w4z+3t5YE-oSOx3QhHiQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, Nov 25, 2011 at 12:53 PM, Jeff Janes <jeff(dot)janes(at)gmail(dot)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
| Attachment | Content-Type | Size |
|---|---|---|
| bulkwal_copy_1.patch | application/octet-stream | 881 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2011-11-25 23:02:45 | Re: Add pg_upgrade ENABLE_SAME_CATVERSION_UPGRADES macro for testing to |
| Previous Message | Alvaro Herrera | 2011-11-25 21:28:20 | Re: [COMMITTERS] pgsql: Enable CHECK constraints to be declared NOT VALID |