pgsql: Speedup COPY FROM with additional function inlining. - Mailing list pgsql-committers

From Nathan Bossart
Subject pgsql: Speedup COPY FROM with additional function inlining.
Date
Msg-id E1vtUvM-000LcW-2T@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Speedup COPY FROM with additional function inlining.

Following the example set by commit 58a359e585, we can squeeze out
a little more performance from COPY FROM (FORMAT {text,csv}) by
inlining CopyReadLineText() and passing the is_csv parameter as a
constant.  This allows the compiler to emit specialized code with
fewer branches.

This is preparatory work for a proposed follow-up commit that would
further optimize this code with SIMD instructions.

Author: Nazir Bilal Yavuz <byavuz81@gmail.com>
Reviewed-by: Ayoub Kazar <ma_kazar@esi.dz>
Tested-by: Manni Wood <manni.wood@enterprisedb.com>
Discussion: https://postgr.es/m/CAOzEurSW8cNr6TPKsjrstnPfhf4QyQqB4tnPXGGe8N4e_v7Jig%40mail.gmail.com

Branch
------
master

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

Modified Files
--------------
src/backend/commands/copyfromparse.c | 18 ++++++++++++++----
1 file changed, 14 insertions(+), 4 deletions(-)


pgsql-committers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: pgsql: Fix expanding 'bounds' in pg_trgm's calc_word_similarity() funct
Next
From: Tom Lane
Date:
Subject: pgsql: First-draft release notes for 18.3.