Re: test_json_parser/002_inline is kind of slow

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: test_json_parser/002_inline is kind of slow
Дата
Msg-id 172894.1758991429@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: test_json_parser/002_inline is kind of slow  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: test_json_parser/002_inline is kind of slow
Список pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> On 2025-09-26 Fr 8:06 PM, Jacob Champion wrote:
>> Unfortunately it only gives about a 4x speedup on my machine, and I
>> was hoping for much more. (We should really expect this entire thing
>> to run in a fraction of a second.)
>> 
>> Let me know if you think the tradeoff is worth it for now; I can
>> polish it up if so.

> On my (Linux) test it went from 3.75s to 0.78s, nearly 80% reduction. I 
> think the reduction on Windows is likely to be more. So I think this is 
> worth doing.

I tried it on my Mac M4 laptop, and saw the 002 test dropping from
3592 ms to 540 ms, about an 85% savings.  So I agree this is worth
doing.  It's still unclear why Robert is seeing times so much worse
than mine, though.

I didn't read the patch too carefully, but the changes in the
002_inline.pl script itself seem reasonable enough.

            regards, tom lane



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