pgsql: Avoid useless buffer allocations during binary COPY FROM. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Avoid useless buffer allocations during binary COPY FROM.
Date
Msg-id E1juK80-0007fc-Or@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Avoid useless buffer allocations during binary COPY FROM.

The raw_buf and line_buf buffers aren't used when reading binary format,
so skip allocating them.  raw_buf is 64K so that seems like a worthwhile
savings.  An unused line_buf only wastes 1K, but as long as we're checking
it's free to avoid allocating that too.

Bharath Rupireddy, tweaked a bit by me

Discussion: https://postgr.es/m/CALj2ACXcCKaGPY0whowqrJ4OPJvDnTssgpGCzvuFQu5z0CXb-g@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/cd22d3cdb9bd9963c694c01a8c0232bbae3ddcfb

Modified Files
--------------
src/backend/commands/copy.c | 20 +++++++++++++++-----
1 file changed, 15 insertions(+), 5 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Avoid trying to restore table ACLs and per-column ACLs in parall
Next
From: Michael Paquier
Date:
Subject: pgsql: Include replication origins in SQL functions for commit timestam