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) ? -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
