From: | Michael Paquier <michael(at)paquier(dot)xyz> |
---|---|
To: | Andres Freund <andres(at)anarazel(dot)de> |
Cc: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | Re: Speeding up COPY TO for uuids and arrays |
Date: | 2024-02-19 03:36:52 |
Message-ID: | ZdLM1NdbUBArxlYo@paquier.xyz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | shveta malik | 2024-02-19 03:38:55 | Re: Synchronizing slots from primary to standby |
Previous Message | Michael Paquier | 2024-02-19 03:20:12 | Re: Returning non-terminated string in ECPG Informix-compatible function |