Re: benchmarking Flex practices - Mailing list pgsql-hackers

From John Naylor
Subject Re: benchmarking Flex practices
Date
Msg-id CACPNZCuQUejMsKy1Ym42-Z8o3T8MDOHffG_uSDc0aJ=3VbueFA@mail.gmail.com
Whole thread Raw
In response to Re: benchmarking Flex practices  (John Naylor <john.naylor@2ndquadrant.com>)
Responses Re: benchmarking Flex practices
List pgsql-hackers
I wrote:

> I no longer use state variables to track scanner state, and in fact I
> removed the existing "state_before" variable in ECPG. Instead, I used
> the Flex builtins yy_push_state(), yy_pop_state(), and yy_top_state().
> These have been a feature for a long time, it seems, so I think we're
> okay as far as portability. I think it's cleaner this way, and
> possibly faster.

I thought I should get some actual numbers to test, and the results
are encouraging:

           master       v10
info       1.56s        1.51s
str        1.18s        1.14s
unicode    1.33s        1.34s
uescape    1.44s        1.58s


--
John Naylor                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Gavin Flower
Date:
Subject: Re: color by default
Next
From: Melanie Plageman
Date:
Subject: Re: Extracting only the columns needed for a query