Re: Speeding up COPY TO for uuids and arrays

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Speeding up COPY TO for uuids and arrays
Дата
Msg-id ZdLM1NdbUBArxlYo@paquier.xyz
обсуждение исходный текст
Ответ на Re: Speeding up COPY TO for uuids and arrays  (Andres Freund <andres@anarazel.de>)
Список 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

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Returning non-terminated string in ECPG Informix-compatible function
Следующее
От: shveta malik
Дата:
Сообщение: Re: Synchronizing slots from primary to standby