On 8/21/22 20:46, Jeff Janes wrote:
>
> You can see there that little time was spent reading data, so that
> explains why repeating the query didn't make it much faster due to
> caching. The time isn't spent reading data, but doing CPU work on
> data already in memory.
>
> Cheers,
>
> Jeff
Agreed. The "perf top" output produced by Kenny definitely indicates
that. That's precisely why I concentrated on JIT. Anything else would
give us a slim chance of increasing the query speed.
Regards
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com