Re: test_json_parser/002_inline is kind of slow - Mailing list pgsql-hackers

From Jacob Champion
Subject Re: test_json_parser/002_inline is kind of slow
Date
Msg-id CAOYmi+==2G8SYddQz09+=QjaxeBF1fVTpYUc3S-HJzhjQRkxZw@mail.gmail.com
Whole thread Raw
In response to Re: test_json_parser/002_inline is kind of slow  (Jacob Champion <jacob.champion@enterprisedb.com>)
List pgsql-hackers
On Fri, Sep 26, 2025 at 9:26 AM Jacob Champion
<jacob.champion@enterprisedb.com> wrote:
> If it's truly just a few lines, then I've misunderstood what you're
> suggesting (patches welcome). It's not the separator splitting that
> I'm worried about, but the restructuring of the test.

Here is a very slapdash attempt at pushing the "chunk size iteration"
part of the tests down into the test executable, using null
separators. I think it's ugly, but maybe not quite as bad as I feared.
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.

Thanks,
--Jacob

Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: V18 change on EXPLAIN ANALYZE
Next
From: Maciek Sakrejda
Date:
Subject: Re: V18 change on EXPLAIN ANALYZE