Re: COPY speedup - Mailing list pgsql-hackers

From Pierre Frédéric Caillaud
Subject Re: COPY speedup
Date
Msg-id op.uyjjpmdfcke6l8@soyouz
Whole thread Raw
In response to COPY speedup  (Pierre Frédéric Caillaud<lists@peufeu.com>)
Responses Re: COPY speedup  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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) ?


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Table and Index compression
Next
From: Pierre Frédéric Caillaud
Date:
Subject: Re: Table and Index compression