Btreefs generates executable code at runtime to unpack btree nodes

• Nominatim

  35 2,875 9.5 Python

  Open Source search based on OpenStreetMap data

  

I have had a lot of "fun" with this feature in the past. It has earned a permanent place in my setup script:

ALTER SYSTEM SET jit=off;

Basically a performance blackhole for more complex queries. Most OSM related projects disable it straight away as it only creates headaches.

https://github.com/osm-search/Nominatim/pull/2559

• openstreetmap-carto

  34 1,487 6.2 CartoCSS

  A general-purpose OpenStreetMap mapnik style, in CartoCSS

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• ClickHouse

  208 34,153 10.0 C++

  ClickHouse® is a free analytics DBMS for big data

  

Manually constructing machine code (as in the example) is not the best idea - it is error-prone, difficult to debug, and prevents testing with sanitizers. I'd not do it.

Using LLVM for JIT is also not the best idea because LLVM is a complex codebase with bugs. Example: https://github.com/ClickHouse/ClickHouse/issues/50323#issuec... Although there are some marginal benefits: https://clickhouse.com/blog/clickhouse-just-in-time-compiler...

Suggest a related project