Re: Speeding up COPY TO for uuids and arrays - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Speeding up COPY TO for uuids and arrays
Date
Msg-id ZdLM1NdbUBArxlYo@paquier.xyz
Whole thread Raw
In response to Re: Speeding up COPY TO for uuids and arrays  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
On Sat, Feb 17, 2024 at 12:24:33PM -0800, Andres Freund wrote:
> I wonder if we should move the core part for converting to hex to numutils.c,
> we already have code the for the inverse. There does seem to be further
> optimization potential in the conversion, and that seems better done somewhere
> central rather than one type's output function. OTOH, it might not be worth
> it, given the need to add the dashes.

I'd tend to live with the current location of the code, but I'm OK if
people feel differently on this one, so I'm OK with what Laurenz is
proposing.

>> - Patch 0003 speeds up array_out a bit by avoiding some zero
>>   byte writes.  The measured speed gain is under 2%.
>
> Makes sense.

+1.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Returning non-terminated string in ECPG Informix-compatible function
Next
From: shveta malik
Date:
Subject: Re: Synchronizing slots from primary to standby