Re: COPY speedup

From: Pierre Frédéric Caillaud <lists(at)peufeu(dot)com>
To: Pierre Frédéric Caillaud <lists(at)peufeu(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: COPY speedup
Date: 2009-08-12 08:40:24
Message-ID: op.uyjjpmdfcke6l8@soyouz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Replying to myself...

I've been examining the code path for COPY FROM too, and I think it is
possible to get the same kind of speedups on COPY FROM that the patch in
the previous message did for COPY TO, that is to say perhaps 2-3x faster
in BINARY mode and 10-20% faster in TEXT mode (these figures are
ballparks, only based on very quick checks however).

The idea is to avoid most (actually, all) palloc()'ing and memcpy()'ing
for types that are pass-by-value like INT.

Is there interest in such a patch (for 8.6) ?

In response to

  • COPY speedup at 2009-08-11 12:50:27 from Pierre Frédéric Caillaud

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pierre Frédéric Caillaud 2009-08-12 08:48:19 Re: Table and Index compression
Previous Message Peter Eisentraut 2009-08-12 08:37:45 Re: Table and Index compression