Re: test_json_parser/002_inline is kind of slow

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, Jacob Champion <jacob(dot)champion(at)enterprisedb(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: test_json_parser/002_inline is kind of slow
Date: 2025-09-29 15:10:55
Message-ID: CA+TgmoZYG50tkM91AcPq_zpGcmhm-71vOh4-S8h5djcRdEgvCw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Sep 27, 2025 at 12:43 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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 don't have a clear explanation for that slowness either, but the
patch cuts down the runtime by 89% on my machine.

(I have not looked at the code.)

--
Robert Haas
EDB: http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2025-09-29 15:15:31 Re: pg_waldump: support decoding of WAL inside tarfile
Previous Message Rafia Sabih 2025-09-29 14:51:13 Re: Bypassing cursors in postgres_fdw to enable parallel plans