Re: Why is pq_begintypsend so slow?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Why is pq_begintypsend so slow?
Дата
Msg-id 28764.1578799965@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Why is pq_begintypsend so slow?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Why is pq_begintypsend so slow?
Список pgsql-hackers
I wrote:
> I saw at this point that the remaining top spots were
> enlargeStringInfo and appendBinaryStringInfo, so I experimented
> with inlining them (again, see patch below).  That *did* move
> the needle: down to 72691 ms, or 20% better than HEAD.

Oh ... marking the test in the inline part of enlargeStringInfo()
as unlikely() helps quite a bit more: 66100 ms, a further 9% gain.
Might be over-optimizing for this particular case, perhaps, but
I think that's a reasonable marking given that we overallocate
the stringinfo buffer for most uses.

(But ... I'm not finding these numbers to be super reproducible
across different ASLR layouts.  So take it with a grain of salt.)

            regards, tom lane



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

Предыдущее
От: John Naylor
Дата:
Сообщение: Re: [proposal] de-TOAST'ing using a iterator
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: logical decoding : exceeded maxAllocatedDescs for .spill files