Re: appendBinaryStringInfo stuff

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: appendBinaryStringInfo stuff
Дата
Msg-id CAApHDvrEFqv1J14Hd41ySFxztPEoLzPQBvSPGaQaQmcXZdwW5g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: appendBinaryStringInfo stuff  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
Ответы Re: appendBinaryStringInfo stuff  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: appendBinaryStringInfo stuff  (David Rowley <dgrowleyml@gmail.com>)
Список pgsql-hackers
On Tue, 20 Dec 2022 at 09:23, Peter Eisentraut
<peter.eisentraut@enterprisedb.com> wrote:
> AFAICT, the code in question is for the text output of the jsonpath
> type, which is used ... for barely anything?

I think the performance of a type's output function is quite critical.
I've seen huge performance gains in COPY TO performance from
optimising output functions in the past (see dad75eb4a and aa2387e2f).
It would be good to see some measurements to find out how much adding
the strlen calls back in would cost us. If we're unable to measure the
change, then maybe the cleanup patch would be nice. If it's going to
slow COPY TO down 10-20%, then we need to leave this or consider the
inline function mentioned by Andres or the macro trick mentioned by
me.

David



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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: meson files copyright
Следующее
От: Tom Lane
Дата:
Сообщение: Re: appendBinaryStringInfo stuff